Macro from MS Access to e-mail Report hangs

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

Guest

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?
 
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.
 
Back
Top