Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →How to use mail merge in Gmail depends on your account and recipient data: an eligible Google Workspace account can send up to 1,500 personalized recipients per message, using direct contacts or a Google Sheet. Gmail replaces tags such as @firstname and keeps recipients in separate threads.
Gmail mail merge is available from the Compose window through Use mail merge. The feature is designed for personalized campaigns, newsletters, and announcements, but it is not a full email-marketing platform: daily quotas, consent requirements, unsubscribe behavior, and unsupported Gmail features matter before you send.
![Google Workspace Guide: Unlock Every Google App – Elevate Efficiency with Exclusive Tips, Time-Savers & Step-by-Step Screenshots for Quick Mastery [II EDITION]](https://m.media-amazon.com/images/I/41CX0AjJhAL._SL160_.jpg)
Key takeaways
- Gmail mail merge sends individualized copies of one message, and each recipient receives a separate thread without seeing the other recipients.
- Google currently lists Workspace Individual, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus as eligible plans for Gmail mail merge.
- Gmail mail merge supports up to 1,500 recipients per message and 1,500 mail-merge recipients per day, subject to the account’s overall sending quota.
- A Google Sheet can provide custom fields such as company, event name, appointment date, renewal date, or account manager.
- Gmail automatically adds a unique unsubscribe link when mail merge is enabled, but unsubscribe controls do not replace consent or legal compliance.
- Mail merge cannot be used with replies, forwards, scheduled send, confidential mode, or a different sending domain, including a secondary domain or alias.
How to use mail merge in Gmail with recipients in the To field
Gmail mail merge sends one personalized copy of a message to each recipient instead of exposing a shared recipient list. The feature uses merge tags such as @firstname, @lastname, @fullname, and @email. Google describes the feature as suitable for personalized campaigns, newsletters, and announcements; the exact controls and eligibility are documented in Google’s Gmail mail-merge instructions.
- Open Gmail on a computer.
- Click Compose, or open an existing draft.
- Add the recipients to the To line.
- Click Use mail merge beside the To field.
- Turn on Mail merge.
- Click in the message body and type
@. - Select a merge tag, such as
@firstname,@lastname,@fullname, or@email. - Review the personalized message and click Send.
Gmail creates an individualized message for every recipient. Recipients do not see the other people included in the mail merge, and replies are organized into separate conversation threads. Gmail’s current mail-merge control replaced the earlier multi-send mode.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problems#1 Best Overall
Which merge tags can Gmail use?
Gmail’s built-in mail merge can insert a recipient’s first name, last name, full name, or email address. The available tags depend on the recipient information Gmail can identify from Google Contacts or from the data in an attached spreadsheet.
| Merge tag | Typical value | Data source | Important qualification |
|---|---|---|---|
@firstname |
Alex | Google Contacts or a first-name spreadsheet column | The send can stop if Gmail cannot find a required first name. |
@lastname |
Rivera | Google Contacts or a last-name spreadsheet column | Use only when the recipient data is reliably populated. |
@fullname |
Alex Rivera | Google Contacts or spreadsheet data | The displayed result depends on the available name fields. |
@email |
alex@example.com | The recipient email field | Use carefully because an email address may look unnatural in ordinary prose. |
How to use Gmail mail merge with a Google Sheet
Use a Google Sheet when every recipient needs information beyond a name, such as a company, appointment date, renewal date, event name, or account manager. Gmail reads the column headers in the first tab and turns those headers into available merge fields.
Prepare the spreadsheet first
- Put the recipient data in the first tab of the Google Sheet.
- Include one column containing email addresses.
- Include a first-name column if the message will use a first-name tag.
- Add optional last-name and custom personalization columns, such as
Company,AppointmentDate, orEventName. - Use text values for contact information.
- Keep column headers simple and avoid special characters where possible.
- Check email addresses for invalid characters, duplicate rows, and obvious typing errors.
Column headers determine the merge tags Gmail offers. If a header contains unsupported special characters, Gmail may identify the field by its spreadsheet position instead, such as @A. Clear headers such as FirstName, LastName, and Company make the message easier to review and troubleshoot. Google documents the spreadsheet requirements in its official Gmail mail-merge help page.
Connect the Google Sheet to Gmail
- Open Gmail on a computer and click Compose.
- Click Use mail merge beside the To field.
- Turn on Mail merge.
- Select Add from a spreadsheet.
- Choose the Google Sheet and click Insert.
- Select the spreadsheet columns containing the email address, first name, and optional last name.
- Click Finish.
- Place the cursor in the message body, type
@, and choose a spreadsheet merge field. - Review the message and send it after testing the data and personalization.
| Recipient method | Best for | Personalization source | Key caution |
|---|---|---|---|
| Recipients entered directly | A small, simple list | Google Contacts or names entered with email addresses | Gmail may not know a recipient’s name if the contact data is incomplete. |
| Google Contacts label | A reusable group of contacts | Contacts associated with the selected label | Review the label before sending because the label populates recipients automatically. |
| Google Sheet | Custom fields and larger, carefully managed lists | Column headers and row values in the first tab | Blank or malformed spreadsheet values can cause errors or incorrect personalization. |
How do Google Contacts labels work with Gmail mail merge?
A Google Contacts label can group recipients for a mail merge. Enter the label in the To field, and Gmail populates the associated contacts automatically. Directly entered recipients can use names saved in Google Contacts; when a recipient is not in Contacts, Gmail can derive a first and last name from the name entered with the email address when that information is available.
Before sending to a Contacts label, remove outdated contacts, duplicates, people without appropriate consent, and addresses that should no longer receive messages. A label is a convenient grouping mechanism, not a substitute for list maintenance.
Rank #2
![The Google Workspace Bible: [14 in 1] The Ultimate All-in-One Guide from Beginner to Advanced | Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite](https://m.media-amazon.com/images/I/41AWmhmGFuL._SL160_.jpg)
- The Google Workspace Bible: [14 in 1] The Ultimate All in One Guide from Beginner to Advanced Including Gmail, Drive, Docs, Sheets, and Every Other App from the Suite
- ABIS BOOK
What happens when a recipient is missing a merge value?
Gmail can stop the send when a required merge tag has no value for one or more recipients. For example, a message using @firstname can produce an error when Gmail cannot determine a recipient’s first name.
When Gmail reports a missing value, you can:
- Provide a default value, such as “there,” if the fallback sounds appropriate in the sentence.
- Correct the recipient’s information in Google Contacts.
- Fill in the missing spreadsheet value.
- Remove the recipient from the campaign.
- Replace the personalized wording with a sentence that does not require the missing field.
A neutral fallback is useful only when the resulting sentence remains natural. Test the spreadsheet with a small internal list first, inspect every column header, and confirm that the fallback does not produce awkward or misleading text.
Which Gmail accounts can use mail merge?
Google’s current Gmail Help documentation lists the following eligible plans: Workspace Individual, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus. A standard free @gmail.com account is not included in Google’s current eligibility list for the built-in mail-merge control.
| Account or plan | Built-in mail merge status in Google’s current list |
|---|---|
| Workspace Individual | Eligible |
| Business Standard | Eligible |
| Business Plus | Eligible |
| Enterprise Standard | Eligible |
| Enterprise Plus | Eligible |
| Education Standard | Eligible |
| Education Plus | Eligible |
Free personal @gmail.com account |
Not included in the current eligibility list |
Account administrators and organizational policies can affect feature access. If Use mail merge does not appear, confirm the account’s Workspace edition and ask the administrator whether the feature is available under the organization’s policies. Google can change plan eligibility, interface labels, and quotas, so verify account-specific details in the current Gmail Help documentation before planning a campaign.
What are Gmail mail-merge sending limits?
Gmail mail merge is limited to 1,500 recipients per message and 1,500 mail-merge recipients per day. Google’s documentation says the mail-merge limit operates within the account’s overall daily sending capacity, so ordinary email sent on the same day can reduce the remaining capacity.
Google’s Gmail Help page states that standard Gmail accounts have a daily outgoing-message limit of 500, while work, school, and Workspace Individual accounts typically have a total daily outgoing limit of 2,000. The figures are account-level limits and can be subject to Google’s current policies. Google gives the example of one mail merge to 1,000 recipients followed by another to 500 recipients.
| Limit or quota | Current documented value | How to interpret it |
|---|---|---|
| Mail-merge recipients per message | 1,500 | A single mail-merge send cannot exceed 1,500 recipients. |
| Mail-merge recipients per day | 1,500 | All mail-merge recipients sent that day count toward this limit. |
| Typical total daily outgoing limit for work, school, and Workspace Individual accounts | 2,000 | Regular messages and mail-merge messages share the account’s overall capacity. |
| Daily outgoing limit for standard Gmail accounts | 500 | This general Gmail limit does not make the built-in mail-merge feature available on a free account. |
| Monthly unique-recipient limit | No monthly limit documented for unique mail-merge recipients | Daily quotas still apply, so this does not permit unlimited sending in one day. |
For example, a mail merge to 1,000 recipients followed by a second merge to 500 recipients uses the documented 1,500-recipient daily mail-merge allowance. If the account also needs to send ordinary email, leave room below the overall daily quota rather than planning to use every available merge slot.
How do Cc and Bcc affect mail-merge limits?
Gmail permits only one Cc or Bcc recipient per mail-merge message, and that address receives a copy for every outgoing recipient. Each copy counts toward the sending limit. Spreadsheet-based Gmail mail merge cannot include Cc or Bcc recipients.
Does Gmail mail merge add an unsubscribe link?
Yes. When mail merge is enabled, Gmail automatically adds a unique unsubscribe link to the bottom of each email. A recipient can use the link to unsubscribe or resubscribe, and the sender receives an email notification when that status changes.
Gmail does not provide a complete list of all unsubscribed recipients in the mail-merge interface. Unsubscribe status is tied to the sending identity. For example, a recipient who unsubscribes from support@company.com may still receive mail-merge messages from marketing@company.com. In organizational accounts, recipients cannot unsubscribe from senders within their own organization.
Unsubscribe functionality does not replace consent or legal compliance. Google recommends obtaining appropriate consent, identifying the sender, avoiding deceptive subject lines and headers, and setting reasonable expectations about message frequency. Review Google’s bulk-email best practices before sending promotional or recurring messages.
Free tools Windows power users keep installed
One-click scans. No signup required.
What can Gmail mail merge not do?
Gmail’s native mail merge is useful for straightforward personalized campaigns, but several Gmail features are unavailable when mail merge is enabled.
| Feature | Available with Gmail mail merge? | What to do instead |
|---|---|---|
| New message | Yes | Compose a new message or use an existing draft. |
| Replies | No | Send a normal reply or use a separate workflow. |
| Forwards | No | Create a new message if a personalized send is required. |
| Scheduled send | No | Send manually at the required time or use a separately verified tool. |
| Confidential mode | No | Choose between confidential-mode controls and native mail merge for that message. |
| Different sending domain, secondary domain, or alias | No | Send from the eligible account identity that Gmail permits. |
| Attachments | Yes, but the attachment is copied into every message | Consider a Google Drive link and verify the file’s sharing permissions. |
Why can attachments consume so much storage?
Gmail copies an attachment into every recipient’s message. Google warns that a 10 MB attachment sent to 500 recipients may use approximately 5 GB of storage. A Google Drive link can reduce duplicated storage, but the sender must check that the sharing permission gives the intended recipients access without exposing the file to an unnecessarily broad audience. Google lists this attachment behavior among the mail-merge limitations.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.What is the safest Gmail mail-merge workflow?
The safest Gmail mail-merge workflow combines account verification, list cleaning, a small test, quota planning, and post-send monitoring.
- Confirm eligibility. Verify that the account uses an eligible Workspace plan and that the organization has not restricted the feature.
- Clean the recipient list. Remove duplicates, invalid addresses, outdated contacts, and people who do not have appropriate consent.
- Prepare clear data. Use the first tab of the Sheet, simple column headers, text contact values, and complete fields for every merge tag.
- Test with a small internal group. Check the sender, subject, links, formatting, merge values, fallback wording, attachment behavior, and Drive permissions.
- Plan around quotas. Keep batches comfortably below the daily limits when the account also needs to send ordinary email.
- Check identity and expectations. Confirm the sending address, identify the sender clearly, use a non-deceptive subject line, and avoid promising a frequency the recipient did not expect.
- Send the campaign. Start with a limited batch when the list or content is new.
- Monitor the results. Watch for bounce notices, unsubscribe notifications, spam complaints, and replies that reveal bad data or unclear messaging.
- Record the campaign. Keep the purpose of the campaign and the recipient source so the list can be maintained responsibly.
Should you use a Gmail mail-merge add-on instead?
Use native Gmail mail merge first when the eligible account, 1,500-recipient daily ceiling, available merge fields, and unsupported-feature limitations fit the campaign. A third-party Google Workspace Marketplace add-on may be worth investigating only when the account lacks native mail merge or the workflow requires capabilities Gmail does not provide, such as a different delivery process or more advanced campaign management.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Do not choose an add-on solely because it promises a larger sending volume. Independently verify the vendor’s current pricing, privacy practices, data access, unsubscribe handling, deliverability controls, Workspace permissions, and legal-compliance features before connecting a recipient list.
What is a useful printed companion for broader Workspace help?
Readers who want help with Gmail alongside Sheets, Drive, Calendar, Docs, and other Workspace applications may find Google Workspace For Dummies useful as a broader Google Workspace reference book. The book is optional and should not be treated as a dedicated Gmail mail-merge manual or a requirement for using the built-in feature.
Frequently Asked Questions
Can I use mail merge in Gmail with a free Gmail account?
A free personal Gmail account is not included in Google’s current eligibility list for the built-in Gmail mail-merge control. Google currently lists Workspace Individual, Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, and Education Plus as eligible plans, although administrators and organizational policies can affect access.
How many emails can Gmail mail merge send?
Gmail mail merge supports up to 1,500 recipients per message and 1,500 mail-merge recipients per day. Those recipients count within the account’s overall daily sending capacity, so ordinary email sent the same day can reduce the available quota.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Does Gmail mail merge include an unsubscribe link?
Yes. Gmail automatically adds a unique unsubscribe link to every message when mail merge is enabled. Recipients can unsubscribe or resubscribe, but the feature does not replace consent, sender identification, or applicable legal requirements.
What are the limitations of Gmail mail merge?
No. Gmail mail merge cannot be used with replies, forwards, scheduled send, confidential mode, or sending from a different domain, including a secondary domain or alias. Attachments are supported, but Gmail copies the attachment into every recipient’s message.
The Bottom Line
Gmail mail merge is the simplest native option for sending personalized new messages from an eligible Workspace account. Use direct recipients for basic name personalization, a Google Sheet for custom fields, test a small group first, and plan around the 1,500-recipient-per-message and 1,500-recipient-per-day mail-merge limits.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
