Yet Another Mail MergeThis Add-on to Google Sheets allows you to compose your templated message directly in Gmail, and then send a customised copy to each recipient. The details of recipients (such as names and email addresses) are stored in a Google Sheet. They can be imported from a contact group, or entered manually.
Yet Another Mail Merge is easy to use and is great for simple emails. Note that at the time of writing, it was unable to merge emails with images due to a recent change by Google.
Learn how to install and use Yet Another Mail Merge.
xsMergexsMerge is a Chrome Web Store app that also allows you to compose and send customised messages from Gmail. However, it can also be used to create letters, certificates and other documents by merging Google Docs into PDF files. In addition, these merged PDF files can also be added as attachments to customised emails. Another feature is the ability to insert content from a Google Site as the body of a merged email message.
xsMerge is a great tool for those who want to perform more advanced merge functions. Note that it does require you to be using the Google Chrome web browser (but you’re already using this, aren’t you?!)
Learn how to install and use xsMerge.
We suggest taking a look at both tools to determine which one will work best for you. Let us know what you prefer!