• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

How can I automate sending a newsletter to all 500 contacts, addressing each one individually.

I want to send a newsletter to all my clients.  There are 100 of them in my contacts in Outlook.

I know I can send to all of them at one time, if I put them all in the BCC line.  

However, I want to have 500 separate e-mails go out.  Each from me, to the individual client.  It would also be great if the body of the message starts with "Dear" followed by the clients Name (also found in "My Contacts").

I don't want to manually do this, because it is very time consumiing.  Is there an automated way to get this accomplished:

a) read a text file containing the e-mail address and client name
b) generate a new e-mail containing the e-mail address in the To: line
c) also add "Dear" "ClientName" in the body of the message.

Thanks for your help.
0
LessonsLearned
Asked:
LessonsLearned
  • 2
1 Solution
 
LessonsLearnedAuthor Commented:
Correction:  However, I want to have 100 separate e-mails go out.
0
 
David Johnson, CD, MVPOwnerCommented:
0
 
LessonsLearnedAuthor Commented:
Thank you very much!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now