Macro from MS Access to e-mail Report hangs
 

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?

Macro from MS Access to e-mail Report hangs
 

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.

--
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


"Bill Howard" wrote in message
...
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?

Macro from MS Access to e-mail Report hangs
 

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

Bill

"Ken Slovak - [MVP - Outlook]" wrote:

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.

--
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


"Bill Howard" wrote in message
...
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?

Macro from MS Access to e-mail Report hangs
 

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.

--
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


"Bill Howard" wrote in message
...
Thank you. Is there any way to disable this feature?

Bill