How to loop through a Contact folder to send emails

  • Thread starter Thread starter Rain County
  • Start date Start date
R

Rain County

Specifically, I'd like to send an individual email to each of the 375
Contacts in my 'Special Contacts' folder. (I don't want to send one email
with 375 cc's or bcc's.) Each email can be identical other than the
recipient.

I'd like to know how to do it programmatically, but if there is a simple
user interface way to do it that'd be fine too.

I can do it programmatically from Access VBA, but Outlook's security
'features' take 5 seconds per email that way.
 
Hi,

manually you can drag each Contact into your Inbox.

For the security issues please read:
http://www.outlookcode.com/d/sec.htm There are some ways, also depending
on your OL version.

In general you can loop through the folder with For Each. Then get e.g.
the Contact´s Email1Address property value, call CreateItem for a new
MailItem, assign the mail address and some other infos and call the Send
method.

In the VBA help you´ll find a sample for CreateItem and Send.
 
The easy non-code method that will not trigger security prompts (assuming you have Office XP or 2003) is to use the contacts in that folder as the data source for a Word mail merge.
 
Duh! That was so easy!!!

Thank you Sue!


The easy non-code method that will not trigger security prompts (assuming
you have Office XP or 2003) is to use the contacts in that folder as the
data source for a Word mail merge.
 
Back
Top