Outlook 2003 Security with Macros

[Nik]

Outlook 2003 SP1

When running a macro in Access that automatically converts a query into an
Excel file and sends the file as attachments through email, the Outlook
client prompts prior to sending each file. Is there a way to turn this
prompt off at the client? Maybe a registery hack or something similar?
Thanks!

Nik

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/sec.htm for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers