Gmail Mail Merge: Send 1,500 Personalized Emails/Day

Gmail's built-in Mail Merge feature lets you gmail mail merge send 1500 personalized emails per day — directly from your inbox, no third-party tool required. This guide walks you through every step: setup, contact import, personalization, and the real limitations you need to know before you start.

---

Why BCC Isn't Good Enough for Bulk Email

Most people start with BCC. You paste 50 addresses, write your message, hit send. Recipients don't see each other's addresses — it feels personal enough.

But it's not. BCC is a single email copy sent to many people. There's no personalization, no individual unsubscribe link, and Gmail flags it as suspicious behavior at scale. It's also capped far below 1,500 recipients.

Gmail's Mail Merge solves these problems. Each recipient gets a separate copy of the email, with their own unsubscribe link. That's a meaningful difference for deliverability and compliance.

---

What Is Gmail Mail Merge?

Mail Merge is a native Gmail feature that sends individualized emails to a list of contacts. Every recipient gets their own copy — not a forwarded chain, not a BCC blast.

It supports basic personalization: first name, last name, full name, and email address. You can also pull data from a Google Sheets spreadsheet to populate those fields automatically.

It's useful for newsletters, announcements, and simple outreach. For complex cold email sequences with follow-ups and analytics, you'll need a dedicated tool. More on that below.

---

Prerequisites: Google Workspace Is Required

Mail Merge is not available on free Gmail accounts. You need one of these Google Workspace plans:

• Workspace Individual
• Business Standard
• Business Plus
• Enterprise Starter
• Enterprise Standard
• Enterprise Plus
• Education Standard
• Education Plus

If you're on a free @gmail.com account, Mail Merge won't appear in your interface. Upgrade to Workspace first.

---

Step 1 — Enable Mail Merge in Gmail

Open Gmail in Google Chrome. This matters. Mail Merge has a known compatibility issue with other browsers — Firefox, Safari, and Edge may not display the button.

Compose a new email. In the top-right corner of the compose window, you'll see a "Use Mail Merge" button. Click it. The button turns purple and Google shows a confirmation: each recipient will receive a separate copy with a unique unsubscribe link.

That's it. Mail Merge is now active for this draft.

---

Step 2 — Keep the Unsubscribe Link

When you activate Mail Merge, Gmail automatically adds an unsubscribe link to your email. Don't remove it.

Removing the unsubscribe link increases your spam score. Gmail's algorithm treats it as a signal that you're sending unsolicited bulk mail. Keep it in — it protects your sender reputation and keeps you compliant with CAN-SPAM and GDPR requirements.

Click "Continue," then "Got it." You're ready to add recipients.

---

Step 3 — Add Recipients and Personalization

Type your recipient addresses in the "To" field. You can add them manually or pull from a Google Contacts label (more on that below).

Mail Merge supports four personalization variables:

• @firstname
• @lastname
• @fullname
• @email

Insert them directly into your subject line or email body. Example: "Hi @firstname, here's what we discussed."

The catch: these variables only populate correctly if your contacts have first and last names saved in Google Contacts. An email address alone won't fill in a name — it'll show blank or the raw variable.

---

Step 4 — Create and Import Contacts

For a single test, create a contact manually at contacts.google.com. Add first name, last name, and email. Save. Reload Gmail. The variable will now populate correctly when you preview.

For bulk sending, manual contact creation doesn't scale. You need to import a list.

Option A — Import a CSV into Google Contacts

Go to contacts.google.com → Import → Select your CSV file. Google Contacts will parse the columns and map them to contact fields.

After import, create a label (e.g., "Restaurant New York") and assign your imported contacts to it. Then use that label in the Mail Merge "To" field to address all contacts at once.

Option B — Connect a Google Sheets Spreadsheet

This method gives you more control over data quality. Create a spreadsheet with at least two columns: email and firstname. Add more columns if needed.

Share the spreadsheet with "Anyone with the link" — this allows Gmail to read it. Then in Mail Merge, click "Add from spreadsheet," select your file, and map the columns. Gmail will use the spreadsheet data to populate personalization variables.

This is the better approach for large lists. You can clean data, remove duplicates, and fix formatting before sending.

---

Step 5 — Clean Your Data Before Sending

Raw contact lists are rarely clean. Before connecting your spreadsheet to Mail Merge, run these checks:

Remove duplicates. In Google Sheets: Data → Data cleanup → Remove duplicates. Select the email column. Duplicate emails waste your daily send quota.

Handle special characters. Gmail's Mail Merge struggles with accented characters (é, ü, ñ) in names. They may display incorrectly in the recipient's inbox. Either replace them with standard ASCII equivalents or remove them.

Verify email format. A single malformed address (missing @, extra space) can cause the entire send to fail. Use a spreadsheet formula like =ISNUMBER(FIND("@",A2)) to flag bad addresses.

Spending 10 minutes on data cleaning saves you from wasted sends and deliverability issues.

---

Step 6 — Preview Before Sending

Mail Merge includes a preview function. Use it. Click "Preview" to see how your email looks for a specific recipient — with their name and email populated.

Check for:

• Variables that didn't populate (showing as blank or @firstname)
• Encoding issues with special characters
• Layout problems if you're using a template

Only send once the preview looks correct for at least 3-4 different contacts.

---

Step 7 — Send

Click "Send all." Gmail processes each email individually and sends them as separate messages. Recipients don't see each other's addresses.

You'll get a confirmation showing how many emails were sent. Gmail also notifies you if any recipient unsubscribes — you'll receive an automated email for each unsubscribe event.

---

Where to Get Quality Contacts for Gmail Mail Merge

Mail Merge is only as good as your contact list. A list of 1,500 unverified, outdated emails will get you spam complaints and low open rates.

For B2B outreach targeting local businesses, Google Maps is one of the best sources. It lists millions of businesses with phone numbers, addresses, websites, and — through website scraping — email addresses.

IBLead gives you direct access to a pre-indexed database of 50M+ businesses across 37 countries. Every record includes the business name, address, phone, website, Google rating, review count, and email address extracted from the business website. The database covers 50+ data fields per listing and is updated weekly.

You filter by city, postal code, region, or entire country. Add filters for business category, Google rating, number of reviews, or even the technologies running on their website (160+ detectable technologies). Export to CSV in seconds.

That CSV imports directly into Google Contacts or Google Sheets — ready for Mail Merge. $52 gets you 10,000 verified business contacts. That's $0.004 per lead.

Try it free: Start free — 200 credits, no card required

---

Gmail Mail Merge Limitations You Need to Know

Mail Merge is a solid tool for simple use cases. But it has real constraints. Know them before you build a workflow around it.

1. Daily Send Limit: 1,500 Emails

The hard cap is 1,500 recipients per day. This resets every 24 hours. For most small businesses and freelancers, this is enough. For agencies or high-volume outreach, it's a bottleneck.

2. No Email Sequences

Mail Merge sends one email. That's it. You can't set up a follow-up sequence — "if no reply in 3 days, send this." You can't automate multi-step campaigns. Each send is a one-shot action.

For sequences, you need a dedicated cold email tool like Lemlist, Instantly, or Smartlead. Export your contacts from IBLead as a CSV, then import into whichever tool you use.

3. No Scheduled Sending

You can't schedule a Mail Merge send for 9 AM tomorrow. You send now or you don't send. This limits your ability to optimize send times for open rates.

4. No Analytics

This is the biggest gap. Mail Merge gives you zero feedback. No open rates. No click rates. No bounce data. You're sending blind.

You can't A/B test subject lines. You can't identify which contacts opened your email. You can't measure campaign performance at all.

For newsletters to existing customers, this might be acceptable. For outbound prospecting, it's a serious problem.

5. Limited Personalization

Four variables: first name, last name, full name, email. That's the full list. You can't personalize by company name, job title, city, or any other field — unless you use a workaround with Google Sheets and map a custom column to the "first name" field.

The Google Sheets workaround works, but it's a hack. Dedicated email tools handle this natively.

---

Email Templates and Layouts

Gmail Mail Merge includes a layout selector. You can pick a newsletter-style template and customize the text and colors.

Honest take: layout matters less than copy. A plain-text email with a strong subject line and relevant message outperforms a beautifully designed template with generic content. Don't spend more than 5 minutes on layout.

Focus on the first sentence. If the first sentence doesn't give the reader a reason to keep reading, the layout won't save you.

---

Legal Compliance

Mail Merge doesn't exempt you from anti-spam laws. The rules that apply:

CAN-SPAM (US): Include your physical address, a clear unsubscribe mechanism, and an honest subject line. Gmail's automatic unsubscribe link covers the second point.

GDPR (EU): You need a lawful basis for processing personal data. For B2B outreach to business email addresses, legitimate interest often applies — but document your reasoning.

CASL (Canada): Requires express or implied consent before sending commercial email. Stricter than CAN-SPAM.

Gmail's Mail Merge adds an unsubscribe link automatically. Honor unsubscribe requests immediately. Don't re-add unsubscribed contacts to future lists.

---

FAQ

Can you do a mail merge in Gmail without Google Workspace?

No. Mail Merge requires a paid Google Workspace subscription. It's not available on free @gmail.com accounts. The minimum plan is Workspace Individual.

How many emails can Gmail Mail Merge send per day?

The daily limit is 1,500 emails. This applies to all emails sent from your account in a 24-hour period, not just Mail Merge sends. The limit resets every 24 hours.

Does Gmail Mail Merge work in Firefox or Safari?

Not reliably. The Mail Merge button may not appear in browsers other than Google Chrome. Use Chrome to avoid compatibility issues.

Can I schedule Gmail Mail Merge emails?

No. Gmail's built-in Mail Merge doesn't support scheduled sending. You send immediately or not at all. For scheduled bulk email, use a dedicated email marketing platform.

What's the best way to build a contact list for Gmail Mail Merge?

For B2B outreach, extract business contacts from Google Maps using a pre-indexed database like IBLead. Filter by location, category, and rating. Export to CSV. Import into Google Sheets, clean the data, then connect to Mail Merge. This workflow takes under 15 minutes from search to send-ready list.

---

Final Word

Gmail Mail Merge is a practical tool for sending up to 1,500 personalized emails per day without leaving your inbox. It's free with Google Workspace, requires no setup beyond Chrome, and handles basic personalization well.

Its limits are real: no sequences, no scheduling, no analytics. For newsletters and simple announcements, those limits don't matter much. For cold outreach campaigns where you need follow-ups and open rate data, you'll hit a wall fast.

The quality of your contact list determines your results more than the tool you use. Start with clean, verified, targeted data — and Mail Merge will do its job.

Start free — 200 credits, no card required