View Single Post
  #2  
Old June 10th 08, 01:48 PM posted to microsoft.public.outlook.program_vba,microsoft.public.outlook
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Mapi/CDO Outlook emailing

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


Ads