Email Mail Merge
An Email Mail Merge will let you create a Google Sheet with source information and a Draft Email with Mail Merge Fields to send personalized mass emails from your D-E Google Email Account.
Before You Start
In order to set up your account for Mail Merges, you will need to install a plugin for Google Sheets that will allow us to do a Email Mail Merge. This plugin is called Yet Another Mail Merge. Here is a link to it: https://chrome.google.com/webstore/detail/yet-another-mail-merge/mgmgmhkohaenhokbdnlpcljckbhpbmef?hl=en. Our school has the paid version of this tool, which allows you can emails to a maximum of 1500 recipients per day.
Create your Draft Email
Go to your email and compose a Draft Email for your Mail Merge. For your Mail Merge fields, put in <<Field>>, where "Field" will match your Mail Merge Record table. When you are done writing the Draft Email, click on the X to close it. If prompted, click Yes to save the draft. See the example.
Create Your Mail Merge Record Table
Create a new (or use an existing) Google Sheet for your Mail Merge records. You must have a column for each of the fields you used in your Draft Email, and you must have a column titled "Email Address" which is used by the Mail Merge to know where to send the email. If there is no column named "Email Address", it will ask you which column has the email and it will rename that column to "Email Address".
Start the Mail Merge
- In your Google Sheet, go to Add-ons -> Yet Another Mail Merge -> Start Mail Merge. It will take a few seconds for the Add-on to launch.
- In the Draft drop down box, select your draft email for the Mail Merge. For Sender name and Send from, enter your own name and email address.
- Click Send me a test email to make sure everything looks right. You will receive a test email about how the email will look with all of the fields populated.
- Once you have verified that everything looks right, click Send Emails to complete the Mail Merge.
- Once the emails have been sent, you will get a popup message letting you know how many emails were sent successfully.
- A new column will get added to the Google Sheet called "Merge status". It will mark off which emails were (or were not) sent successfully.