Using the Mail Merge tool with Gmail
1. Open a new or existing Google Sheet
2. Format the Google Sheet
- The column headers in the spreadsheet should be the "merge tag", this is what will be used in the body of the email to reference items in that column.
- The required merge tags are @email and @firstname. You can create more by adding more merge tags in the column headers
- Fill in each row with personalized information for that specific recipient
3. Using Mail Merge Function
- Open Gmail
- Compose an email or open an existing draft, click the people icon next to BCC and check the box to use “Mail Merge”.
4. Select "Add from a spreadsheet" from the same drop-down, and select the spreadsheet that you prepared
5. Use an at symbol @ to add your merge tags to the body of the email
6. Once composed click continue to send a preview of the email to yourself, or send the message to everyone in the @email column
More detailed information can be in Google's Documentation at https://support.google.com/mail/answer/12921167