How do I customize emails when emailing from a distribution list?
Posted Friday, September 17, 2010 by admin
When I email from a distribution list, I want to make the emails custom so that it appears that I wrote each email individually. For example: “Dear Mary,” instead of just a generic “Dear U6 Soccer Parent,”. Is there some bit of code I could stick in an outlook header to customize my message based on the recipient?
The easiest way to do that is to use MS Word mail merge, merging the list of recipients’ name from an excel file and at the last step of the merge it allow merging result to be in form of email.
The only thing left you might need is to get the individual email address from MS outlook to an excel file, here’s the steps.
1. go to outlook menu, file, import and export
2. export to a file, click next
3. click comma separated values(CSV)
4. in the right of 1st box click browse, mark down the folder that the export file will be saved then put the name of your file, then click ok , click finish button.
Since csv file is a excel compatiable file format, you can use that file to build the input file for the use in mail merge,
Hope this helps.