Mail Merge with Gmail and Google Drive

Mail merge with Gmail and Google Drive provides a very simple set of tools to create merged email

What is a mail merge? Wikipedia entry defines it as:

Mail merge is a software function describing the production of multiple (and potentially large numbers of) documents from a single template form and a structured data source.

Do you need to send unique, personalized emails to a list of people? For example:  You are managing a  trade show exhibit for an organization and need to tell each person what time they are supposed to staff the trade show booth. You could send them hand edited individual e-mails or your could simply use the spreadsheet you create to assign times and merge each individual’s time into an email just for them, attaching the whole schedule.  A merged email allows you to employ data contained in a flat database, AKA a spreadsheet, merge it with a saved draft email to produce a unique email specifically for a single recipient.

In the past people did this using desk-top email clients such as Microsoft Outlook, but with Google Drive and Gmail, you can do this without a desktop email application.

What is Google Drive?

Watch a video to learn more about Google Drive.

Google Drive home page with YouTube video about Drive

Visit the Google Drive homepage and watch a brief video to learn more about what Google Drive is and how to use it.

Advantages of merge email with Google Drive and Gmail?

  1. It’s pretty simple.
  2. You can get copies of the individuals emails in your inbox
  3. You can include graphics
  4. You can add attachments
  5. You avoid using desktop-tied applications
  6. Your work is “in the cloud” where you can get to it with all types of devices and from any computer.
  7. You save trees, because you’re not printing and snail-mailing information.
  8. You send everyone on your e-mail list a unique email just for them.

I’ve outlined how to format the mail merge with Gmail, install a simple script into your Google Docs spreadsheet with the specific information for your merge and then perform the merge. The script used is “Yet Another Mail Merge” which you will find by searching the script library as illustrated in the Slide Share presentation.

FacebookPinterestStumbleUponTumblrEmailPrintShare/Bookmark

Related Posts:

This entry was posted in Marketing and tagged , , , . Bookmark the permalink.