Mail Merge in Gmail

Process to send a Mail Merge from Gmail.

Also available Mail Merge from Mailchimp sends using Gmail to send to lists of between 50 and 1000 people.

Install the add on Mail Merge with Attachments - the free edition lets you send up to 50 emails a day via Mail Merge

How to Create Mail Merge with Gmail and Google Sheets

Mail Merge for Gmail lets you send personalized email messages to multiple contacts in one go. The individual messages have almost the same content but some parts of the message can be customized. For instance, you can greet each recipient by their first name, you can include their postal address in the message body, personalize the subject line, attach different files while the other parts of the email body remain the same.

Mail Merge in Gmail is for everyone. If you are organizing a party at your home, you can send personalized email invitations to all your friends with the help of mail merge. A business owner can use mail merge to inform customers about upcoming deals and offers. Sales and marketing teams use Mail Merge for drip campaigns. Teachers can send individual assignments and reports to students through mail merge.

Mail Merge in Gmail

Here’s how you can do mail merge with Gmail:

1. Install the Mail Merge for Gmail add-on. Please watch the Mail merge tutorial for instructions.
2. This will create a new Google Spreadsheet. Go to the Add-ons menu in the sheet, select Mail Merge with Attachments and then select the Create Merge Tempaltemenu.
3. Open Google Contacts and create a new Group with all the contacts who you would like to send a personalized email. Alternatively, you can enter the names and email addresses of recipients directly in the Mail Merge Google Sheet.
4. Under the Mail Merge menu, choose Import Google Contacts and select the Google Contacts group that you created in Step 3. It will now automatically import all the associated Gmail contacts into the spreadsheet.
5. Go to Gmail and create a new draft email messages that will become the template for Mail merge. Alternatively, you can compose an email template in rich text using the HTML Mail tool and then copy-paste the generated HTML code into the message body field of the Google Sheet.
6. If you would like to add file attachment to your email messages – say a PDF file or a Word document – just upload the file to Google Drive and then select Insert File Attachments to insert that link of the file into the Mail merge sheet. Mail Merge will automatically insert the actual file into the email.
7. Go to the Mail Merge menu again and choose “Configure Mail Merge” – the status column will change to “MAIL SENT” for all email messages that were successfully delivered.

It is always a good idea to test your email campaign before sending a blast to multiple people. On the Configure Mail Merge screen, click the “Send a Test Email” button and it will send a sample email to the developer with the {{Variable Fields}} substituted with dummy values. If all the fields have been replaced in the test email, your mail merge is ready to go.

Gmail Mail Merge F.A.Q.

Here are some answers to frequently asked questions around Mail Merge for Gmail and Google Apps:

1. How many email messages can I send per day?

The free edition of Mail merge lets you send 50 emails per day but the limit for Premium edition is different (check your limit). Gmail users can send emails to 100 recipients per day while the daily limit for Google Apps for Work accounts is 1500 recipients per day. The is only available to paid Google Apps for Work accounts.

For more information click here.

Yet Another Mail Merge

Support: https://support.yet-another-mail-merge.com/hc/en-us

Personalize your email content with markers

YAMM TeamUpdated 2 months ago

Personalizing your emails has many advantages. You don't need to type different messages by hand to your whole recipient list, so you're saving a lot of time. It also makes your subscribers feel unique, increasing thus their trust towards your email, and the overall efficiency of your campaign.

How can I personalize my emails?

It's very easy to do so. Simply add a new marker under the format {{Column Header}} in the body of your draft, like in the following example:

Please note that the information inside your marker {{}} has to match exactly the column header of your spreadsheet, as it is upper/lower case sensitive.

Notice how the 'First Name' column header is written: with capitals F and N: The marker should then be exactly {{First Name}}, NOT {{First name}}, or {{first NaMe}} etc.

Beware of invisible spaces behind the column header too!

In the end, the results will look like the following:

Standard markers supported by YAMM

You can use the following markers to personalize your email content (and subject line):

- {{Column Header}}
- <<Column Header>>
- $%Column Header%

We advise to use the markers {{Example}}. This one is the most stable one, and doesn't cause any compatibility issues with Gmail.

Page updated

Report abuse