Using SendObject in Access to send an email

[Dale Fye]

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?

 

[Albert D. Kallal]

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

 

[Mark Andrews]

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

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

 

[Ken Slovak - [MVP - Outlook]]

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.