Microsoft Outlook Warning

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

Guest

I have a macro set to email reports to people. The first line in my macro is SetWarnings, set to Yes (to turn warnings off). When I run the macro, I get a box that says "A program is trying to automatically send e-mail on your behalf. Do you want to allow this?" Then I have to click yes. It does this for each email it sends. Is there a way to get rid of this warning

Thanks
Avyn
 
What you are seeing is the Outlook Security Prompt, which is designed to
inhibit the proliferation of email viruses. Unfortunately the Access
SetWarnings statement will not affect it.

You'll find an extensive review of all of the options available to work
around the Outlook Security Prompt at:

http://www.slipstick.com/outlook/esecup.htm

The easiest work-around that I have found is to install the free ClickYes
utility found at:

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

This utility can be incorporated into VBA code and will automatically click
the 'Yes' button of the security prompt. The writers of this software have
included code at their website which shows you how to turn the Utility on
and off from within your code.


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Avyn said:
I have a macro set to email reports to people. The first line in my macro
Click to expand...
is SetWarnings, set to Yes (to turn warnings off). When I run the macro, I
get a box that says "A program is trying to automatically send e-mail on
your behalf. Do you want to allow this?" Then I have to click yes. It
does this for each email it sends. Is there a way to get rid of this
warning?
 
Back
Top