Access emails

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Automatically sending a batch of emails from Access without getting security
warning each time?
 
Hi greghsi,

Easy--
You can use the freeware application "Click Yes" which automatically clicks
the button for you:
http://www.contextmagic.com/express-clickyes/

Medium--
If you are sending emails by automating Outlook from Access with VBA you can
use Dmitry Streblechenko's "Outlook Redemption" dll to circumvent the
security:
http://www.dimastr.com/redemption/

Hard--
You can also build your own "Click Yes" style routine using VB which will do
the same thing as the Click Yes program, but from within Access. Here is a
link for some ideas on how that might be achieved, though you will have to
figure out some kind of timer system--maybe the Windows API timer:
http://www.freevbcode.com/ShowCode.asp?ID=6654
 
Why not just uncheck the "warn me about other applications trying to send
emails" from your email program? I have Outlook express and I send emails
from Access 97 all the time.
 
greghsi,
If you were speaking of Outlook 200x,
there is no setting to circumvent the security.
 
Back
Top