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

  • Thread starter Thread starter Craig Brody
  • Start date Start date
C

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
 
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,
 
thanks very much Cheryl!!...we are in an Exchange
environment...will try you suggestions
 
Back
Top