Outlook

  • Thread starter Thread starter Anthony Feole
  • Start date Start date
A

Anthony Feole

Hello,

I have a database module that runs reports and e-mails
them to end-users via Outlook. I have setup macros to
handle this process which works really good.
Unfortunately, I would like to automate this entire
process and here's my question:

When sending reports through Macros via Outlook the
following dialog box is displayed and I must manually hit
the "Yes" button to send each and every report.

Dialog Box:

Micrsoft Outlook

A program is trying to automatically send e-mail on your
behalf.

Do you want to allow this?

If this is unexpected, it may be a virus and you should
choose "No"

My options are "Yes" and "No"

Thanks in advance!

Anthony
 
Anthony,

To add to Van's comments ... If you are using Outlook with Exchange, there
is a download available for use at the Exchange level which can manipulate
the Outlook Security prompt. Here is a link with more information:

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

Without Exchange, the simplest and cheapest way to get around the Outlook
Security Prompt is to download and install the free utility, ClickYes, on
each user's computer.

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

Using ClickYes does require VBA code, but their website comes with sample
code which you should incorporate into your code to turn the utility on and
off.

Other suggestions regarding the Outlook Security Prompt, as well as a wealth
of other information about Outlook can be found at:

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


hth,
 
Back
Top