Join group Mergo allows you to create a personalized email template in Gmail and send a mail merge from Google Sheets with Mergo to hundreds of recipients within minute
Access to Mergo is controlled by joining the Lehigh group - https://groups.google.com/a/lehigh.edu/g/mailmerge-list?hl=en
Start Using Mergo
Create Email Draft in GMail
The first thing you can do is create your email draft in Gmail.
...
If you wanted to also include the Recipient's last name in the Email, then you can add
Selecting Mergo
Now that you have your Email Draft, you can open Google Sheets, and you now see the Mergo icon, on the right sidebar
...