Send personalized messages with mail merge from google accounts

Modified on Thu, 24 Apr at 6:33 PM



  1. On your computer, open Gmail.
  2. At the top left, click Compose.
    • You can also open an existing draft.
  3. On the right of the "To:" line, click Use mail merge .
  4. Turn on Mail Merge.
  5. Click Add from a spreadsheet.
  6. Select a spreadsheet.
  7. Click Insert.
  8. In the window, select the columns from your spreadsheet that have recipient info:
    • Email
    • First name
    • Last name (optional)
  9. Click Finish.
    • Your spreadsheet is added to the "To:" line in the message.
  10. In your message, enter @.
  11. Select a merge tag.
    • Merge tags are determined by the column headers in your spreadsheet.
  12. To insert the merge tag, press Enter.


IMP NOTE - MAIL MERGE works with limited Google Plans - Refer: https://support.google.com/mail/answer/12921167?hl=en

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article