What a mail merge does and why you'd use it

A mail merge takes a list of names, email addresses, or other details from a spreadsheet and plugs each person's information into a template email. Instead of writing "Dear John" fifty times, you write the email once with a placeholder, and the mail merge software fills in each person's name automatically. The result is fifty emails that feel personal, even though you wrote them once.

You use mail merge when you're sending the same message to many people but want each recipient to see their own name or details in the email. A nonprofit might use it to send donation thank-yous with each donor's gift amount. A small business might send a price quote with the customer's company name already filled in. A teacher might send grade reports with each student's scores.

Mail merge saves time and reduces mistakes — you're not copying and pasting the same text over and over, and you're not accidentally sending the wrong details to the wrong person.

Key Takeaways

  • Mail merge requires two things: a template email with placeholders (like [FirstName]) and a spreadsheet with one column per piece of information you want to insert.
  • Gmail, Outlook, and Google Docs all have mail merge options, though Gmail requires a third-party tool like Mail Merge by Gmail or Mailmodo.
  • Your spreadsheet must have headers in the first row — "FirstName", "Email", "Company" — and the mail merge tool matches those headers to the placeholders in your email.
  • Always send a test email to yourself first to check that names, amounts, and other details are inserting correctly before sending to your full list.
  • Mail merge through Gmail or Outlook sends emails one at a time from your account, so recipients see your email address, not a bulk-sender address.

Setting up your spreadsheet with the right structure

Your spreadsheet is the engine that drives the mail merge. Open a new Google Sheet, Excel file, or CSV file — any spreadsheet program works. The first row must contain headers: the names of the pieces of information you're inserting. If you want to insert someone's first name, put "FirstName" in the first cell. If you want their email address, put "Email" in the next cell. If you want their company name, put "Company" in the next.

Below those headers, enter one row per person. Each column holds one piece of information. So if your headers are FirstName, LastName, Email, and Company, your second row might be: John, Smith, john.smith@example.com, Acme Corp. The third row is the next person, and so on. Make sure there are no blank rows in the middle — the mail merge tool reads from the first data row straight down until it hits an empty row.

Column names matter because the mail merge tool uses them to match placeholders in your email. If your spreadsheet says "FirstName" but your email template says [First_Name], the tool won't find the match. Use simple, consistent names with no spaces or special characters — FirstName, not First Name; Company, not Company Name.

Writing your email template with placeholders

Open a new email in Gmail, Outlook, or whichever service you're using. Write the email as you normally would, but wherever you want information from your spreadsheet to appear, insert a placeholder. The exact format depends on your mail merge tool, but most use square brackets: [FirstName], [LastName], [Email], [Company].

For example, your email might say: "Hi [FirstName], Thank you for your donation of [DonationAmount]. Your gift will help us [ProjectName]. Best regards, Sarah." When the mail merge runs, it replaces [FirstName] with John, [DonationAmount] with 50, and [ProjectName] with "build a community garden" — one set of values per email.

The placeholders must match your spreadsheet headers exactly. If your spreadsheet column is named "FirstName" but you type [firstname] in lowercase, the tool won't recognize it. Check your mail merge tool's documentation for the exact bracket style it uses — some use [brackets], some use {braces}, and some use other formats.

Using mail merge in Gmail with a third-party tool

Gmail doesn't have built-in mail merge, so you'll need a helper tool. Two common ones are Mail Merge by Gmail (made by Google) and Mailmodo. Both work similarly: you install them from the Chrome Web Store, then access them from within Gmail.

To use Mail Merge by Gmail: open Gmail, click the Google Apps menu (the grid icon in the top right), find "Mail Merge by Gmail", and click it. A sidebar opens. Paste or upload your spreadsheet data, then write your email template in Gmail's compose window using the placeholders that match your column headers. Click "Preview" to see what one email will look like with real data filled in. If it looks right, click "Send" and choose how many emails to send per day — this prevents your account from looking suspicious to Gmail's filters. The tool sends emails from your Gmail address, one at a time.

Mailmodo works similarly but has a slightly different interface. Both are free for small lists (usually under 100 emails) and charge for larger ones.

Using mail merge in Outlook

Outlook has mail merge built in, though it's a bit hidden. You'll use Word to create the template, then Outlook to send. Open Microsoft Word and write your email template with placeholders like [FirstName]. Go to the "Mailings" tab at the top. Click "Start Mail Merge" and choose "Email Messages". Click "Select Recipients" and choose "Use an Existing List", then navigate to your spreadsheet file.

Word will ask you to identify which row contains your headers — click the row with FirstName, Email, Company, and so on. Then click "Insert Merge Field" wherever you want a placeholder to appear in your email. A dropdown menu shows all the column headers from your spreadsheet. Click the one you want, and Word inserts it as a merge field (it looks like [FirstName] but with special formatting).

Click "Preview Results" to see what the emails will look like with real data. If everything looks correct, click "Finish & Merge" and choose "Send Email Messages". Word will ask which column contains the email addresses — select "Email" or whatever you named that column. Then click "OK" and Word sends the emails through Outlook.

Using mail merge in Google Docs and Sheets

Google Docs doesn't have native mail merge, but you can use a free add-on called Mail Merge for Docs. Install it from the Google Workspace Marketplace. Open a new Google Doc and write your email template with placeholders like [FirstName]. Go to "Extensions" in the menu, find "Mail Merge for Docs", and click "Start Mail Merge".

A sidebar opens asking you to select your spreadsheet and which sheet contains your data. Choose your Google Sheet with the recipient list. The add-on reads your column headers and shows them in the sidebar. Click on each placeholder in your document and select which column it should pull from. So you'd click [FirstName] and tell it to use the FirstName column.

Click "Preview" to see a sample email with real data. If it looks right, click "Send Emails" and the add-on sends one email per row in your spreadsheet, using your Google account.

Testing before you send to everyone

Before sending to your full list, always send a test email to yourself. Most mail merge tools have a "Preview" or "Test" button that shows you exactly what one email will look like with real data inserted. Use it. Check that names are spelled correctly, that amounts or dates are in the right format, and that the email reads naturally with the inserted information.

Common mistakes to watch for: a placeholder that didn't get replaced (it still says [FirstName] instead of John), a column header that doesn't match the placeholder (so nothing inserts), or data in the wrong column (so someone's company name appears where their name should be). Catching these before sending saves you from sending fifty broken emails.

After you've reviewed the preview, send one real test email to your own email address. Open it in your inbox and read it as a recipient would. Check that links work, that formatting looks right, and that the tone feels natural with the personalized details included.

Frequently Asked Questions

What if my spreadsheet has blank cells?

If a cell is blank, the placeholder in that email will be blank too. So if John Smith's company cell is empty, his email will say "Dear John Smith, Thank you for your interest in [Company]" with [Company] showing as blank. Either fill in all cells before running the merge, or rewrite your template to handle blanks — for example, "Thank you for your interest" instead of "Thank you for your interest in [Company]".

Can I schedule mail merge emails to send later?

Gmail's Mail Merge by Gmail and Mailmodo don't have a schedule feature — they send immediately. Outlook's mail merge also sends right away. If you need to send at a specific time, you can write and preview the merge, then manually send a smaller batch now and another batch later, or use a paid email marketing tool like Mailchimp that has scheduling built in.

What happens if I make a typo in a placeholder?

If you type [FirstName] in your email but your spreadsheet column is named "First_Name" (with an underscore), the mail merge tool won't recognize the placeholder. It will send the email with [FirstName] still showing as text instead of inserting the actual name. Always check that placeholders match column headers exactly, including capitalization and spacing.

Can I use mail merge to send to people outside my organization?

Yes. Mail merge works with any email addresses in your spreadsheet, whether they're inside your company, outside it, or a mix. The emails come from your account, so recipients see your email address and your organization's name (if you've set that up in your email signature).

Is mail merge the same as a mailing list?

No. A mailing list (like a Google Group or Outlook distribution list) sends one email to many people, and everyone sees all the other recipients. Mail merge sends individual emails to each person, and each recipient sees only their own email address. Mail merge is better when you want emails to feel personal or when you don't want recipients to see who else received the message.