Macro from MS Access to e-mail Report hangs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Howard - 28 Sep 2006 19:34 GMT

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?

Reply to this Message

Ken Slovak - [MVP - Outlook] - 28 Sep 2006 20:24 GMT

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.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm

>I run a macro in Access that outputs a report (.snp) which is then
>e-mailed.
[quoted text clipped - 10 lines]
> to
> disable this interruption from Outlook's toolbar?

Reply to this Message

Bill Howard - 29 Sep 2006 13:31 GMT

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

Bill

> See http://www.outlookcode.com/d/sec.htm.
>
[quoted text clipped - 15 lines]
> > to
> > disable this interruption from Outlook's toolbar?

Reply to this Message

Ken Slovak - [MVP - Outlook] - 29 Sep 2006 14:02 GMT

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.

Signature

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

Reply to this Message