Overview
This article explains how to use YAMM (Yet Another Mail Merge), an add-on to Google Sheets and Gmail to mail merge customized emails to the recipients.
Instructions
Prerequisites
1. You are required to log in with the same Google account that you used to create the spreadsheet in Google Sheets and the email template in Gmail
2. The spreadsheet should contain the contact information with the emails
3. Prepare an email template saved in the Drafts in your Gmail account.
Procedure
1. In Google Sheets, open the spreadsheet with the contacts list.
2. Select Extensions > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
3. You will get a prompt to confirm permissions.
4. Then it will prompt you to continue to YAMM with your Oswego credentials. Once you sign in you will need to allow access to your Google account. Click Allow.
5. In the Start Mail Merge window, configure the mail merge.
a. Note that YAMM correctly detects column A as the Email column.
b. Type the name from which you send the mail merge in the Sender Name text box.
c. Select the email template from the Email Template drop-down menu that you created.
d. Click the Send emails button to send the mail merge to all recipients in the Google spreadsheet.
Helpful Tips
- You can only send 1500 recipients at one time so be sure to break down your email list into smaller groups and send multiple emails.
- Do not forget to create the email template beforehand and if it does not appear then click on the refresh icon beside the email template in the start mail merge box.
Need Help?
Need additional information or assistance? Contact CTS.