NOTE TO MERGO USERS: Our license for Mergo has been extended through June 2025.
Mergo allows you to create a personalized email template in Gmail and perform a Mail Merge from Google Sheets with Mergo to hundreds of recipients within minutes
Video Demo - https://lehighonline.hosted.panopto.com/Panopto/Pages/Viewer.aspx?id=acba0941-e018-4252-9b1a-af3a00bff41c
Access to Mergo is controlled by joining the Lehigh group - https://groups.google.com/a/lehigh.edu/g/mailmerge-list?hl=en
...
Now that you have your Email Draft, you can open Google Sheets , and you should now see the Mergo icon on the right sidebar
After selecting the Mergo icon. Select the Cateogy Category that says says Mergo - Merge for Gmail 
Once you choose Mail Merge for Gmail. you should see the four headers appear on your Google Sheet
Email Address - Place the Email Address of the recipients in this column
First Name - Place the recipient's first name in this column
Last Name - Place the recipient's last name in this column
Merge Status - Leave this blank
...
Once you are ready to run Mail Merge, select Send Mail. Highlighted in Blue indicates the gmail Daily quota which would be of 2000 Emails
After running Mergo's Mail Merge Campaign, you should receive a status update in Merge Status Column indicating if the message was Sent or Opened
...