What mail merge does

A mail merge is a feature that pulls information from a list — usually names, addresses, or email addresses — and drops that information into a template letter or email. Instead of typing the same message fifty times with different names, you write it once with placeholders, and the software fills in the blanks automatically.

The result is a set of personalized messages that look like you wrote each one individually. Your recipient sees their own name and details, not a generic "Dear Customer" or a list of everyone else's names.

Mail merge lives in Microsoft Word, Google Docs, and most email programs. It is a built-in tool, not something you read separately.

Key Takeaways

  • Mail merge pulls names and details from a spreadsheet and inserts them into a template, so you write once instead of many times.
  • You need two files: a template with placeholders and a data source (usually a spreadsheet) with the actual names and information.
  • The merge creates individual messages that look personalized, which is why recipients see their own name rather than a generic greeting.
  • Mail merge works in Word, Google Docs, Gmail, and Outlook, though the steps and limitations differ slightly between programs.

The two files you need

Mail merge requires a template and a data source. The template is the message itself — the letter or email with placeholders where the personal details go. The data source is a spreadsheet (usually in Excel, Google Sheets, or a CSV file) with one row per person and one column per piece of information.

Your spreadsheet might look like this: a column for first names, a column for last names, a column for company names, a column for email addresses. Each row is one person. The template then says something like "Dear [FirstName], thank you for your business at [CompanyName]." When you run the merge, it replaces [FirstName] and [CompanyName] with the actual values from each row.

The column headers matter. If your spreadsheet says "First_Name" in the header, the template must reference [First_Name], not [FirstName]. Most mail merge tools show you the available column names when you set up the merge, so you can pick the right ones.

How to set up mail merge in Microsoft Word

Open Word and create your template message. Type the body of the letter or email, then position your cursor where you want the first piece of personal information to go. Click the Mailings tab at the top, then click Select Recipients. Choose Use an Existing List and navigate to your spreadsheet file.

Word will ask you which sheet to use (if your file has multiple sheets) and whether the first row contains headers. Say yes to headers. Then click Insert Merge Field and choose the column name you want to insert — for example, [FirstName]. Word drops that placeholder into your template. Repeat for each piece of information you need.

Once your template is complete, click Finish & Merge. You can preview the merged messages one by one before you send or print them. If something looks wrong, go back and fix the template or the data source, then run the merge again.

How to set up mail merge in Google Docs

Google Docs does not have a built-in mail merge feature. Instead, you use a free add-on called Mail Merge for Gmail (made by Google) or a third-party add-on like Merge. Install the add-on from the Extensions menu, then click Mail Merge for Gmail (or whichever add-on you chose).

Create your template in Google Docs and add placeholders like {{FirstName}} or {{LastName}}. The add-on will show you the exact syntax to use. Then open the add-on panel, point it to your Google Sheet with the data, and it will create a draft email for each row. You can review them before sending.

The main difference from Word is that Google's version is designed for email, not printing. If you need to print merged letters, Word is the simpler choice.

How to set up mail merge in Gmail and Outlook

Gmail does not have native mail merge. Use the Mail Merge for Gmail add-on (search for it in the Chrome Web Store, then install it in Gmail). Create your template email in Gmail with placeholders, then use the add-on to pull names and addresses from a Google Sheet. The add-on generates individual draft emails that you can review and send.

Outlook has a mail merge feature built into the desktop version. Click Mailings in the ribbon, then Start Mail Merge, and follow the same steps as Word. Outlook will create individual emails in your drafts folder, ready to send. The web version of Outlook does not have mail merge; you must use the desktop process.

Common mistakes and how to avoid them

The most frequent error is a mismatch between placeholder names and column headers. If your spreadsheet column is called "Email" but your template says [EmailAddress], the merge will fail or leave blanks. Check the exact spelling and capitalization of every column header before you start.

Another common problem is extra spaces or line breaks in your data. If a name has a trailing space ("John "), the merge will include that space, which looks sloppy. Clean your spreadsheet before you merge: remove leading and trailing spaces, fix inconsistent capitalization, and delete any blank rows.

A third mistake is forgetting to save your template after you insert merge fields. If you close Word or Google Docs without saving, you lose the placeholders and have to start over. Save early and often.

When mail merge makes sense and when it does not

Mail merge is worth the setup time if you are sending more than about ten personalized messages. For three or four, typing them individually is faster. For fifty or five hundred, mail merge saves hours.

Mail merge also works best when the information is straightforward — names, addresses, dates, straightforward facts. If you need to write different content for different people (a custom paragraph for each recipient), mail merge becomes awkward. You would need to add conditional logic, which most mail merge tools do not support well.

If your data is messy — inconsistent formatting, missing values, typos — spend time cleaning it first. A mail merge with bad data produces bad messages at scale, which is worse than writing them by hand.

Frequently Asked Questions

Can I use mail merge to send emails directly, or do I have to create drafts first?

It depends on the tool. Word creates individual documents that you then have to copy into email manually. Gmail's Mail Merge add-on creates draft emails in your inbox that you review and send. Outlook's mail merge also creates drafts. If you want to send directly without reviewing each one, Gmail's add-on is the fastest option, though reviewing first is safer.

What if some people in my list are missing information?

Mail merge will leave that field blank. If a row has no email address, the merge will show an empty space where the email should be. You can either delete those rows before merging, or review the merged messages and skip the incomplete ones before sending.

Can I merge into an email signature or footer?

No. Mail merge works only in the body of the message. If you need personalized information in a signature, you would have to add it manually to each message after the merge is complete.

Do I need to redo the merge if I add new people to my list?

Yes. Mail merge reads your data source at the moment you run it. If you add new rows to your spreadsheet after the merge, you have to run the merge again to include them. The old merged messages do not update automatically.

Is mail merge the same as a mailing list?

No. A mailing list (like a newsletter list) sends the same message to everyone. Mail merge personalizes each message with individual details. They serve different purposes.