Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

Join group 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. 

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 appear on your Google Sheet
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

Import a recipient list from Sheets or Excel

Want to send your email to more than a few people? List your recipients in Google Sheets or Microsoft Excel file and import it in Mergo!

For example:

Click on the more options button and select Import recipients from Sheets / Excel:

Use the file picker to select a Google Sheets or import a Excel file:

You are ready to launch your campaign! Click on Send N emails and Mergo will send your emails!

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.

  • No labels