Sending Emails From Access Causes Security Warnings

[Chas]

Hey Folks,
I am trying to automate a macro in Access (2003) that runs 4 queries and
then sends the results via email (outlook 2003) with an Excel attachments to
various people.
I get a warning message from Outlook for every email that the macro is
triggering and sending. I must click allow this message to send or the emails
do not send correctly.
Can this warning message be removed from Outlook 2003 so that there is no
user interaction needed? Is there a registry edit or setting that I am
overlooking to permanently disable this?

Thanks for any help and info
Chas

 

[Ken Slovak - [MVP - Outlook]]

See http://www.outlookcode.com/d/sec.htm for your options.

 

[Chas]

It looks like the free version of express click press does the trick.
http://www.contextmagic.com/express-clickyes/
Its just to bad that MS hasn't implemented a selectable admin feature to
easily control this.
Hint .Hint... 2007 Are you listening lol

Thanks again,
Chas

 

[John Blessing]

Hey Folks,
I am trying to automate a macro in Access (2003) that runs 4 queries and
then sends the results via email (outlook 2003) with an Excel attachments
to
various people.
I get a warning message from Outlook for every email that the macro is
triggering and sending. I must click allow this message to send or the
emails
do not send correctly.
Can this warning message be removed from Outlook 2003 so that there is no
user interaction needed? Is there a registry edit or setting that I am
overlooking to permanently disable this?

Thanks for any help and info
Chas

You can try to code around it, or you could avoid Outlook altogether and use
an smtp component such as jmail to send your email.

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook, find/replace,
send newsletters

 

[Chas]

We had thought about it but since we are trying to do this with multiple
users and we still need track what was sent within our Outlook/Exchange. This
just seems like something that the admin should be able to control. Should be
similar to setting the macro security levels or similar.

 

[Sue Mosher [MVP-Outlook]]

On a machine with up-to-date anti-virus protection, as shown in the Trust Center, Outlook 2007 will not trigger security prompts from external applications.

Earlier versions of Outlook have had administrative control of the security prompts since 1999 in Exchange environments; see http://www.slipstick.com/outlook/esecup/admin.htm

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

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

It looks like the free version of express click press does the trick.
http://www.contextmagic.com/express-clickyes/
Its just to bad that MS hasn't implemented a selectable admin feature to
easily control this.
Hint .Hint... 2007 Are you listening lol

Thanks again,
Chas

See http://www.outlookcode.com/d/sec.htm for your options.

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

Hey Folks,
I am trying to automate a macro in Access (2003) that runs 4 queries and
then sends the results via email (outlook 2003) with an Excel attachments
to
various people.
I get a warning message from Outlook for every email that the macro is
triggering and sending. I must click allow this message to send or the
emails
do not send correctly.
Can this warning message be removed from Outlook 2003 so that there is no
user interaction needed? Is there a registry edit or setting that I am
overlooking to permanently disable this?

Thanks for any help and info
Chas