How to Send Personalized Bulk Email with Gmail Mail Merge

Tap through the steps below to see exactly how it works.

  1. Prepare your recipient list spreadsheet

    Set up a spreadsheet with columns for name, email address, and any details you want personalized.

  2. Enable multi-send mode in Gmail

    Turn on "Multi-Send Mode" (sometimes found under Labs or Settings) in your Gmail settings.

  3. Compose your email with merge tags

    In "Compose", connect your spreadsheet and write your message using merge tags like the recipient's name.

  4. Preview each version, then send

    Preview how the email will look to each individual recipient, then send the full batch.

  5. Why this is useful

    You can send a personalized email with each person's own name to dozens or hundreds of recipients at once, without writing each one individually.

Personal touch without the manual effort

A generic "Dear valued customer" email gets ignored far more often than one that starts with the recipient's actual name. Mail merge lets you send hundreds of individually personalized messages while writing the content only once, striking a balance between efficiency and a genuine personal feel.

Keep your spreadsheet clean before sending

Since the merge pulls data directly from your spreadsheet columns, double-check for typos in email addresses and consistent formatting in name fields before sending. A misspelled email address means that recipient never gets the message, and an inconsistent name format (all caps, nicknames, etc.) can make a personalized email look sloppy instead of thoughtful.

Frequently Asked Questions

Will recipients see the addresses of everyone else the email was sent to?

No, mail merge sends each email as an individual message, so no recipient sees any other recipient's name or email address.

Is there a limit to how many emails I can send this way in one day?

Yes, most webmail providers cap daily sending volume, so check your provider's current sending limits before planning a very large batch.