Sending e-mail from Access-VBA code gives Outlook Warning Message

[JeffSydor]

At work, I use a VBA routine from within Access to send a series of Excel
files to appropriate recipients. When the code runs, it gives this message
for each "send" making it necessary to click "Yes" repeatedly. Here's the
message:

(Title Bar of Window): MS Office Outlook
(Message): A program is trying to sutomatically send e-mail on your behalf.
Do you want to allow this? If this is unexpeced, it may be a virus and you
should choose "No".

Does anyone know how I can prevent the message and have the code run without
intervention?

 

[Jocelyn Fiorello]

See if the information on the following page helps:

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