Email Mail Merge using YAMM
An Email Mail Merge using Yet Another Mail Merge (YAMM) 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 (YAMM). Here is a link to it: https://workspace.google.com/marketplace/app/yet_another_mail_merge_mail_merge_for_gm/52669349336.
The free version of YAMM is available to all and has a limit of 50 emails / user / day.
Our school has a limited number of license to the paid version of this tool, which allows you to email a maximum of 1500 recipients per day. Create a support request for Computer Services via the front page of help.d-e.org if you need access to the paid version.
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" matches a column headings of the Google Sheet with your Mail Merge data. 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.