A free version of “Yet Another Mail Merge” allows you to send up to 50 emails per day. A personal plan costs $24 per year and allows you to send up to 400 emails per day. There are other mail merge add-ons you can install too. Try different ones to see which one you like best.

If you don’t see the Google account you want to use, click Use another account and sign in with the email address and password associated with your Google account.

You can also import contact information by clicking Add-ons and then selecting Yet Another Mail Merge. Select Import Contacts and then select Google Contacts or Other CRMs. Select a contact group using the drop-down menu next to “Groups”, and then click Import Contacts.

If you aren’t logged in, click your Gmail account, or click Use another account and sign in with the email address and password associated with your Gmail account.

You can pull information from your spreadsheet by typing $%[Header]% in your email message. For example, if you want to address the recipient by their first name, you would type something like Hello $%First% in the email message. This will pull the contacts name from the email. [2] X Research source

The “#” in the “Send # Emails” displays the number of emails you will be sending. Click Receive a Test Email to send yourself a test email before sending the email to everyone in your spreadsheet.