Using SendObject in Access to send an email
 

I've got some code in Access an Access 2007 database that generates a series
of email messages to a bunch of customers.

Unfortunately, the security settings of Outlook popup a warning menu with
each email that is generated. As I recall, in Office 2003, when this
happened, the user was presented with an option to allow that functionality
for a period of time, so they did not have to repeatedly wait for the warning
message to finish processing and then click the Accept button. Is there a
way to do this in Access/Outlook 2007 as well?

----
HTH
Dale

Using SendObject in Access to send an email
 

I was under the impression that in 2007, this message is gone.

Try either ensuing that access is in a trusted location, or try setting
macro security to low....

I have access 2007, but only have outlook 2003....

Try either of the above ideas....I don't have the reference, but I do recall
reading somwhere that that nag prompt is gone in one of the above cases....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

Using SendObject in Access to send an email
 

You could always go with a third party smtp component and avoid all these
issues.

Mark
RPT Software
http://www.rptsoftware.com

"Dale Fye" wrote in message
...
I've got some code in Access an Access 2007 database that generates a
series
of email messages to a bunch of customers.

Unfortunately, the security settings of Outlook popup a warning menu with
each email that is generated. As I recall, in Office 2003, when this
happened, the user was presented with an option to allow that
functionality
for a period of time, so they did not have to repeatedly wait for the
warning
message to finish processing and then click the Accept button. Is there a
way to do this in Access/Outlook 2007 as well?

----
HTH
Dale

Using SendObject in Access to send an email
 

Low security isn't a good idea. However, in Outlook 2007 if you have an up
to date anti-virus program running the prompt won't occur in out of process
uses of the Outlook object model. SendObject() is a Simple MAPI call, not
Outlook object model. The results might be better if Outlook object model
code were used instead of a Simple MAPI call.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Albert D. Kallal" wrote in message
...
I was under the impression that in 2007, this message is gone.

Try either ensuing that access is in a trusted location, or try setting
macro security to low....

I have access 2007, but only have outlook 2003....

Try either of the above ideas....I don't have the reference, but I do
recall reading somwhere that that nag prompt is gone in one of the above
cases....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada