Macro from MS Access to e-mail Report hangs

[Bill Howard]

I run a macro in Access that outputs a report (.snp) which is then e-mailed.
In previous versions of Outlook, this worked fine. In 2003, a message is
displayed "A program is trying to automatically send an e-mail message using
Microsoft Visual Application (VBA) command, Item.Send, from within Microsoft
Outlook."

This effectively halts the email from being sent automatically and requires
a manula confirmation to proceed - which defeats the purpose. Any idea how to
disable this interruption from Outlook's toolbar?

 

[Ken Slovak - [MVP - Outlook]]

See http://www.outlookcode.com/d/sec.htm.

The security restrictions were added to Outlook in Outlook 2000 SP2, BTW,
it's not a recent development.

 

[Bill Howard]

Thank you. Is there any way to disable this feature?

Bill

 

[Ken Slovak - [MVP - Outlook]]

Only if you are using Exchange server and the admins use the security form
to allow those actions. The link I provided discusses that and shows the
workarounds that are available.