Mail Merge
November 4th, 2006
To broadcast an email to a large group, most people would simply paste all their addresses into the BCC field of the email. While this does work, it’s less-than-optimal, and some SPAM email filters will block an email with too many bcc listings.
I’m not a fan of Windows but it does offer a convenient email solution to broadcast personalized messages, called Mail Merge. To use it, take all your subscriber information and put it in an Excel spreadsheet. Then draft your message in Word, substituting the Excel column names in places where you want to tailor your message, such as Dear [first_name] ...
When you’re ready to send the message, go to Tools -> Letters and Mailings -> Mail Merge.
The rest of the process is fairly self-explanatory, but you can download complete instructions here.
Sorry, comments are closed for this article.