Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
Image RemovedImage Removed

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.

Image Removed

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,

Image Added

If you wanted to also include the Recipient's last name in the Email, then you can add

Image Added

Image Added

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

Image Added

After selecting Mergo icon. Select Mergo - Merge for Gmail 
Image Added

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

Image Added

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.

Image Added