Using Excel to automate e-mails sent from Outlook?

**Shelter417** · 02-25-2012, 02:56 PM

Is there a way to automate e-mails, using a spreadsheet as a template? I have a survey that I need to send out, and I was hoping to make the task a little simpler.

I've attached a sample workbook: basically, I'd want to send an e-mail to the address listed in column A, while using the information in column B to manage the greeting.

For example, the first line of the e-mail might look something like:

Dear [Name in Column B],

...with the rest of the e-mail remaining the same regardless of the person that it's being sent to.

**DGagnon** · 02-25-2012, 03:12 PM

This can be accomplished using "Mail Merge" in MS Word, once in word, go to Mailings - Start Mail Merge - E-Mail Messages. you can then import your excel sheet with E-Mail addresses and Names to use by going to "Select Recipients" - "Use Existing List" and loading your excel file in.

at this point you can type your sample e-mail, using the insert merge field to enter the names. once completed click on Finish & Merge, Send E-Mail Messages, and you're all set.

**icestationzbra** · 02-25-2012, 03:12 PM

for this, you have to use Mail Merge functionality through Word into Outlook.

following website has instructions:

http://www.howto-outlook.com/howto/mailmerge.htm