What mail merge does

A mail merge takes a list of names, addresses, or other information and automatically fills them into a template letter or email. Instead of typing the same message fifty times with different names, you create one template with placeholders — like «First Name» or «Company» — and the mail merge tool pulls data from a spreadsheet or database to fill in those blanks for each person. The result is fifty personalized letters that look handwritten but were generated in seconds.

The most common use is sending bulk emails or letters where each recipient sees their own name and details. A nonprofit might use it to send thank-you letters to donors with each person's donation amount. A small business might send price quotes to customers with their specific product selections. A teacher might generate report cards with each student's grades already filled in.

Mail merge is built into Microsoft Word, Google Docs, and most email platforms. It is not a separate program you need to download — it is a feature inside tools you probably already use.

Key Takeaways

  • Mail merge pulls names and details from a spreadsheet and inserts them into a template, so each recipient sees a personalized message without you typing it fifty times.
  • You need two things: a template document with placeholders (like «First Name») and a data source like a spreadsheet with columns for each piece of information.
  • Microsoft Word and Google Docs both have mail merge features built in, accessible through the Tools or Mailings menu.
  • Mail merge works for email, letters, labels, and envelopes — anything where the same content repeats with different names or details swapped in.
  • Common mistakes include mismatched column names between your template and spreadsheet, or forgetting to save your data file before starting the merge.

How to set up a mail merge in Microsoft Word

Start by creating your data source — a spreadsheet with one row of column headers and one row per person. If you are sending letters to customers, your columns might be: First Name, Last Name, Company, Address, City, State, Zip. Save this as a .csv or .xlsx file and keep it open or nearby.

Open Word and write your template letter. Type the body of the message as you want it to appear, then click the Mailings tab at the top. Click Start Mail Merge and choose the type of document — Letters, Email Messages, Envelopes, or Labels. Then click Select Recipients and choose Use an Existing List, then navigate to your spreadsheet file.

Now place your cursor where you want the first piece of data to appear — for example, after «Dear » in the greeting. Click Insert Merge Field and select the column name from your spreadsheet, like «First Name». Word inserts a placeholder like ««First Name»». Repeat this for every piece of information you want to pull in: address, company name, or any other detail from your spreadsheet.

When your template is complete, click Finish & Merge and choose whether you want to merge to a new document (which creates one file with all the letters) or send directly to email. If you choose email, Word will send each message to the address in the column you specify.

How to set up a mail merge in Google Docs

Google Docs does not have a built-in mail merge feature, but you can use a free add-on called Mail Merge for Gmail or Yet Another Mail Merge. Open the add-ons menu (the puzzle piece icon on the left sidebar), search for one of these, and install it.

Create your data source as a Google Sheet with column headers in the first row. Share the sheet so the add-on can read it, or have it open in another tab. In your Google Doc, write your template and insert placeholders by typing {{First Name}} or {{Company}} — the exact column name from your sheet in double curly brackets.

Open the add-on from the left sidebar, select your Google Sheet as the data source, and preview how the merge will look. The add-on will either create a new document with all merged letters or send emails directly, depending on which add-on you chose and what options you select.

Common mistakes and how to avoid them

The most frequent problem is a mismatch between your template placeholders and your spreadsheet column names. If your spreadsheet says «FirstName» (no space) but your template says «First Name» (with a space), the merge will not recognize the match and will leave that field blank. Before you start, write down your exact column names and use them consistently in your template.

Another common error is forgetting to save your data file before opening the mail merge dialog. Word and Google Docs need to read the file from disk, so if you have unsaved changes, the merge tool may not see your latest data. Save your spreadsheet, close it, then start the merge process.

A third mistake is merging to email without testing first. Always do a test merge to a new document and check a few examples before sending to your full list. Look for missing data, formatting problems, or typos in the template that you did not catch before. Once you send emails, you cannot unsend them.

When mail merge is the right choice

Mail merge saves time when you are sending the same message to more than about ten people and each person needs to see their own name or specific details. For three or four people, typing individual emails is often faster. For hundreds of people, mail merge is essential.

Mail merge also works well when you need a record of what was sent. If you merge to a new Word document, you have one file with all the letters, which you can print, save, or archive. If you send directly to email, you have a sent folder with each message.

Mail merge is less useful if your message needs to be truly different for each person — not just different names, but different content based on their situation. In that case, you are better off writing each message individually or using a more advanced tool like a customer relationship management (CRM) system.

Mail merge for labels and envelopes

You can use mail merge to print address labels or envelopes without typing each address by hand. In Word, click Start Mail Merge and choose Labels or Envelopes instead of Letters. Select your label or envelope size from the dialog, then insert merge fields for address, city, state, and zip in the correct positions. When you merge, Word creates a sheet of labels or a stack of envelopes with all addresses filled in.

This is especially useful for nonprofits sending bulk mail, small businesses shipping orders, or anyone mailing to more than a handful of addresses. You can then print directly onto label sheets or envelope stock.

Frequently Asked Questions

Can I use mail merge to send emails through Gmail?

Yes, but not directly from Gmail. You use a Google Doc template with an add-on like Mail Merge for Gmail or Yet Another Mail Merge, which reads your data from a Google Sheet and sends emails through Gmail on your behalf. The emails appear to come from your Gmail account, but the add-on handles the personalization and sending.

What if my spreadsheet has blank cells?

Mail merge will insert nothing in that spot — the placeholder will simply disappear. If you have a blank last name for one person, the greeting might read «Dear John » with an extra space. To avoid this, either fill in all cells before merging or use a more advanced tool that can handle conditional text.

Can I merge data from a Google Sheet into a Word document?

Yes. Download your Google Sheet as a .csv or .xlsx file, then use that file as your data source in Word's mail merge dialog. Alternatively, if you are using Google Docs, use one of the mail merge add-ons, which can read Google Sheets directly without downloading.

Is mail merge the same as a mailing list?

No. A mailing list is just a collection of email addresses. Mail merge uses a mailing list plus a template to create personalized messages. You need both the list and the template for mail merge to work.

Can I undo a mail merge after I send it?

No. Once emails are sent, they cannot be recalled. This is why testing with a small group first is important. If you merged to a new document instead of sending directly, you can review the document before printing or sending anything.