You start mail merges with YAMM from the Google spreadsheet containing the contacts information.
Prerequisites
- Make sure that you are logged in with the same Google account you used to create the spreadsheet in Google Sheets and the email template in Gmail
- Your Google spreadsheet contains the contacts information with the mandatory Email column.
- You have an email template saved in the Drafts folder of your Gmail account.
Procedure
- In Google Sheets, open the spreadsheet with the contacts list.
- Select Add-ons > Yet Another Mail Merge: Mail Merge for Gmail > Start Mail Merge.
- Click Continue.
info With a Free plan, you can send mail merges to up to 50 recipients per day.
At this step, YAMM offers you to purchase a Personal plan and send mail merges to up to 400 recipients per day. Click Personal plan to go to the YAMM pricing plans page from which you can purchase the Personal plan and increase the daily number of recipients to which you can send mail merges. - In the Start Mail Merge window, configure the mail merge.
- Note that YAMM correctly detects column A as the Email column.
- Type the name from which you send the mail merge in the Send Name text box.
- Select the email template from the Email Template drop-down menu.
info If the drafted email template does not appear in the list, click the Refresh button.
- Note that YAMM correctly detects column A as the Email column.
- Click the Send emails button to send the mail merge to all recipients in the Google spreadsheet.
Result
You have now sent your first mail merge! YAMM sends an email to your account congratulating you for your first mail merge.
What’s next
You can check the sent emails by opening the Sent folder in Gmail.
If you enabled tracking of the mail merge, opening any of the sent emails impacts the Opened number of emails in the Tracking Report. Because of this, only review the sent emails and do not open them to avoid misrepresentations in the data in the Tracking Report.
Related articles
