How can I automate sending a newsletter to all 500 contacts, addressing each one individually.
Posted on 2013-05-24
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.