While using the

docmd.sendobject

statement in Access 2007, I keep getting an Outlook dialog box that says,

"A program is trying to send an e-mail message on your behalf. If this is
unexpected, click Deny and verify your antivirus software is up-to-date."

Fortunately, we have a SMTP server, and I was able to use (modify) the code
posted by BCullenward from the site:

http://www.access-programmers.co.uk/...ad.php?t=97854

Now, it works GREAT! And is super fast too. No more security alerts from
Outlook.

I hope this helps.

"Cam" wrote:

Hello,

I have a macro in Excel to update data, then email the updated file to
people on the distribution list. The problem is once the macro is ran, it
popup a screen asking whether it is ok to send the email out (must be a
security reason in outlook?). I want to put in the code to by pass the popup
cause I want the macro to run automatically during the weekend.

Thanks