Access email using Outlook

[Bill Munro]

I am trying to send a block of e-mails (maybe up to 100)
from Access using Outlook. I have tried a number of
ways. However the dreaded "A Program is trying to
automatically send e-mail behalf. Do you want to allow
this?" pops up with each Send command. Is there a way to
avoid this so that the end user does not have to answer
this question 100 times?

 

[Joe Fallon]

You may need to use a program named ClickYes! in order to use the
SendEmailMessage code.
Oultook security now pops up dialog boxes that you can't program around.
ClickYes! looks for them and "clicks the Yes button" for your code.

http://www.express-soft.com/mailmate/clickyes.html