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.
What is Google Drive?
Watch a video to learn more about Google Drive.
Advantages of merge email with Google Drive and Gmail?
- It’s pretty simple.
- You can get copies of the individuals emails in your inbox
- You can include graphics
- You can add attachments
- You avoid using desktop-tied applications
- Your work is “in the cloud” where you can get to it with all types of devices and from any computer.
- You save trees, because you’re not printing and snail-mailing information.
- 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.