How to eliminate message prompt appearing when sending email during Access Macro

[Craig Brody]

In my macro, I have a Send Object command that sends
Access reports to several individuals. However, when it
is about to send the report (during the macro run) I have
to click Yes EACH TIME to the following message prompt:
=====
"A program is trying to automatically send email on your
behalf.

Do you want to allow this?

If this is unexpected, it may be a virus and you should
choose No"
=====
How can I avoid this message prompt appearing and have it
just send the reports to relevant individuals without
stopping me with this prompt?

Thanks for any assistance, suggestions

Regards

 

[Cheryl Fischer]

These messages are the result of increased security for Outlook which is
built-in and, unless you are working in an Exchange environment, cannot be
turned off. For more information, see:
http://www.outlookcode.com/d/sec.htm

To work around this feature, I have been pleased with Express Soft's free
utility called "ClickYes", available for download at:
http://www.express-soft.com/mailmate/clickyes.html. It does not make the
security prompt go away, but it does use api calls to click the 'Yes' button
for you.

Here is a link to a thread where you can find code that will check to see
whether ClickYes is running, start the utility, run email-related code, and
then turn the utility off. http://tinyurl.com/3x3xj

ClickYes is not the only work-around or option available; others can be
found at: http://www.outlookcode.com/d/sec.htm

hth,

 

[Craig Brody]

thanks very much Cheryl!!...we are in an Exchange
environment...will try you suggestions