Using SendObject in Access to send an email

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

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?
 
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....
 
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.
 
Back
Top