Mail merge guides for Gmail
Updated October 29, 2026
Plain, tested guides for sending personal emails to a list from your own Gmail. Each one shows the free or built-in way first, then how Mergeline does it. Every Gmail limit links to Google’s own help page. Need a quick fact instead? Browse the answers.
Getting started
How mail merge in Gmail works, with the tools Google gives you and with an extension.
- How to mail merge in GmailMail merge in Gmail step by step: Google’s built-in mail merge, Sheets add-ons, Apps Script and a free Chrome extension, with the daily limit for each.
- How to mail merge from Google Sheets to GmailMail merge from Google Sheets to Gmail: set up the sheet, map columns to merge tags, handle empty cells, and send with Gmail’s tool, an add-on or Mergeline.
- How to mail merge from Excel or a CSV file into GmailHow to mail merge from an Excel file or CSV into Gmail: clean the file, fix encoding and date problems, and send personal emails without Word or Outlook.
- Gmail’s built-in mail merge: who has it, its limits and why the button is missingWhich Google Workspace plans include Gmail’s mail merge, its 1,500 a day limit, what it can’t do, and why the mail merge button is missing on your account.
- How to send individual emails to multiple recipients in Gmail without BccHow to send one email to many people in Gmail so each gets their own copy and nobody sees the other addresses. Why Bcc falls short and how mail merge fixes it.
Limits, spam and privacy
How much you can send, how to stay out of spam and what tracking really costs you.
- Gmail sending limits explainedGmail sending limits from Google’s own pages: 500 a day on free accounts, 2,000 on Workspace, 1,500 for mail merge, 500 on trials, and what happens at the cap.
- How to avoid spam when sending bulk email from GmailKeep a Gmail mail merge out of spam: Google’s sender rules (SPF, DKIM, 0.3% spam rate), a safe sending pace, list cleaning, writing tips and what not to add.
- Why open tracking pixels hurt deliverability and privacyHow open tracking pixels work, why Apple Mail Privacy Protection makes open rates unreliable, how pixels can hurt inbox placement, and what to measure instead.
- How to send cold email from Gmail safelyHow to send cold email from Gmail or Google Workspace without getting suspended: limits for external recipients, pacing, list quality, writing and follow-ups.
Personalizing and following up
Merge tags, attachments, follow-ups, tests and timing.
- How to mail merge in Gmail with attachmentsSend a Gmail mail merge with attachments: the same PDF to everyone, or a different file per person such as invoices or certificates, with honest workarounds.
- How to personalize a mail merge with merge tags, fallbacks and conditional textHow to personalize a Gmail mail merge with merge tags, fallbacks for empty cells, conditional sentences and varied wording, with examples you can copy.
- How to send follow-up emails in Gmail that stop on replyHow to send automatic follow-up emails from Gmail that stop when someone replies: timing, what to write, Gmail’s own options and how Mergeline does it.
- How to A/B test subject lines in a Gmail mail mergeHow to A/B test subject lines in a Gmail mail merge: split the list, judge by replies not opens, how many people you need and what to test first.
- How to schedule a mail merge in Gmail and set sending hoursHow to schedule a mail merge in Gmail: why the built-in merge cannot be scheduled, how to send at a set time, and how to send in each person’s time zone.
Guides by role
Real workflows for job seekers, recruiters, teachers, nonprofits and agents.
- Mail merge for job seekers: personal applications from GmailHow job seekers can send personal applications and cold emails to recruiters from Gmail with mail merge, without sounding like a mass email.
- Mail merge for recruiters: personal candidate outreach from GmailHow recruiters can send personal candidate outreach from Gmail with merge tags, conditional text, follow-ups that stop on reply and review-first drafts.
- Mail merge for teachers: email each parent individuallyHow teachers can email each parent individually from a class spreadsheet with Gmail: one email per family, siblings, review-first drafts and school data tips.
- Mail merge for nonprofits: personal donor and volunteer emailsHow nonprofits can send personal donor thank-yous, volunteer updates and event recaps from Gmail with mail merge, and when a newsletter tool fits better.
- Mail merge for real estate agents: stay in touch from GmailHow real estate agents can email past clients and their sphere from Gmail with personal details, home anniversaries, open house follow-ups and safe pacing.
Mergeline does this from your own Gmail. Free for 60 emails a day with merge tags and no branding. Pro is $12 a month or $99 a year for follow-ups, scheduling and attachments.