You need to call Send for each item to send it. See
http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security prompts.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Jon Lewis @btinternet.com" jon.lewisnospam wrote in message ...
I'm using a mapi/cdo routine (based on code from Sue Mosher) to generate a
mass email from a CRM Access application.
I'm looping through a recordset adding email body/attachments etc and then
objOutlookMsg.Close (olSave)
objOutlookMsg.Move objOutlookDestFolder
for each message saves the email to the Outlook Outbox and only one security
warning is thrown for the entire session which is fine.
However, all the messages in the Outbox are non-italicised, i.e. each one
has to be opened up and Send clicked.
If I add objOutlookMsg.Send to the loop, I get a separate security dialog
box for each email
How can I avoid this.
TIA