Using Mail Merge in Gmail

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
 

 

 

Print Article