Thursday, 24 April 2014

Perform a mail merge using Google Apps



Mail merge allows you to create and send personalised emails and documents to lists of people. Google Apps does not have its own mail merge feature. However, there are several add-ons that provide this functionality. In this blog post, we’ll look at how you can use Yet Another Mail Merge or xsMerge to perform a mail merge using Google Apps. These two tools will help you eliminate the need to revert to using traditional desktop office applications for mail merging!


Yet Another Mail Merge

This 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.


xsMerge

xsMerge 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!


1 comment:

  1. […] month we published a blog post on performing a mail merge in Google Apps using Yet Another Mail Merge or xsMerge. Since then […]

    ReplyDelete

Popular Posts