Join group Access to them Mergo is controlled by joining the Lehigh group - https://groups.google.com/a/lehigh.edu/g/mailmerge-list?hl=en
Start Using Mergo
In Gmail, Google Sheets, or Docs:
Move your mouse to the bottom-right corner and click the Show slide panel button to unhide it > click the Mergo app
Send a test email to yourself
This feature is available in our add-ons for Google Sheets, Docs, and Gmail.
At the top right of the sidebar, open the more options menu, and select Send a test email to myself.
A test email will be sent to you.
You can directly see it in your inbox, or click on View test email to open it in a new tab.
...
Create Email Draft in GMail
The first thing you can do is create your email draft in Gmail.
Please note: The Subject Title of the Draft is what will appear as the Subject Message for the recipients once you run Mail Merge
In the email draft you will need to use Merge brackets to specify the Recipient's First Name,
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
After selecting Mergo icon. Select Mergo - Merge for Gmail
Once you choose Mail Merge for Gmail. you should see the four headers come up
Email Address - This is where you put the Email Address of the recipients in this column
First Name - Place the first name only in this column
Last Name - Place the Last name only in this column
Merge Status - Leave this blank
List your recipients in Mergo sidebar
If you want to send separately your email to a few recipients only, you can directly list the email addresses separated by comma in Mergo sidebar
...
Note: Mergo will use the first row of your sheet to fill the merge fields from your Gmail draft as an example, and it will deduct one email from your quota.