What mail merge does and why you'd use it

Mail merge is a Word feature that takes a single document — a letter, label, or email — and automatically fills in different names, addresses, or other details from a list. Instead of typing "Dear Sarah" in one letter, "Dear Marcus" in another, and so on, you write the letter once with a placeholder, then Word fills in each person's name automatically.

The most common use is sending personalized letters to dozens of people without retyping the same text. You might also use it to create mailing labels, envelopes, or a set of documents where only certain fields change — like a contract template where the client name and date shift but the terms stay the same.

Mail merge requires two things: the main document (your letter or template) and a data source (a list of names, addresses, or other information). Word pulls information from the data source and inserts it into the main document wherever you've placed merge fields.

Key Takeaways

  • Mail merge needs two files: a main document with merge fields (placeholders) and a data source with the actual names and addresses.
  • Your data source can be an Excel spreadsheet, a CSV file, or even a Word table — the column headers become the merge field names.
  • You insert merge fields into your main document using the Mailings tab, and Word shows you a preview before you create the final merged documents.
  • After merging, you can save all personalized documents as a single file, print them directly, or send them as individual emails.

Prepare your data source before you start

Your data source is the list of information Word will pull from. The easiest format is an Excel spreadsheet or a CSV file (comma-separated values), though Word can also read from an Access database or a Word table.

Set up your data source with column headers in the first row. If you're merging names and addresses, your columns might be: FirstName, LastName, Street, City, State, ZipCode. Word uses these exact header names as merge field names, so make them clear and spell them consistently — no spaces or special characters. Each row below the headers contains one person's information.

Save your data source before you open Word. If it's an Excel file, save it as .xlsx. If you're starting from scratch and want a simple format, save it as a CSV file (File > Save As > CSV UTF-8). Word can read both without trouble.

Open the main document and connect to your data

Create or open the letter or document you want to use as your template. This is the document where you'll add merge fields.

Go to the Mailings tab at the top of Word. Click Start Mail Merge, then choose the type of document you're creating: Letters, Email Messages, Envelopes, Labels, or Directory. For a standard personalized letter, choose Letters.

Next, click Select Recipients. Choose Use an Existing List, then browse to your data source file (the Excel or CSV file you prepared). Word will ask you to confirm which sheet or table contains your data. Click OK, and Word now knows where to pull the information from.

Insert merge fields into your document

Now you'll place merge fields wherever you want Word to insert personalized information. A merge field is a placeholder that tells Word "put the person's first name here" or "put their address here."

Click in your document where you want the first name to appear — usually after "Dear " in the greeting. Go to the Mailings tab and click Insert Merge Field. A dropdown menu shows all the column headers from your data source. Click the one you want — for example, FirstName. Word inserts a field that looks like <<FirstName>>.

Continue inserting merge fields wherever they belong. If you're creating a full address block, you might insert FirstName, then a space, then LastName. For a mailing address, insert Street on one line, then City, State, and ZipCode on the next. Word lets you type regular text (like commas or line breaks) between merge fields.

A shortcut: if you're inserting a full address, click Address Block instead of Insert Merge Field. Word creates a formatted address field automatically, pulling from your data source columns. You'll match your column names (like "Street" or "City") to what Word expects, and it handles the spacing and punctuation.

Preview and test your merge

Before you create 50 merged documents, check that everything looks right. Click Preview Results on the Mailings tab. Word shows your document with the first person's information filled in. Use the arrow buttons to scroll through a few records and make sure names, addresses, and other details are in the right places.

If a merge field is blank or in the wrong spot, click Preview Results again to turn off the preview, then fix the document. Check that your data source has the information you're trying to merge — if a column is empty or misspelled, Word won't find it.

Complete the merge and save or print

Once the preview looks correct, click Finish & Merge on the Mailings tab. You have three options:

  • Edit Individual Documents opens a new Word file with all merged documents combined into one. You can then edit specific letters if needed, or print them all at once.
  • Print Documents sends all merged letters directly to your printer without creating a new file.
  • Send Email Messages (only available if you chose Email Messages in the Start Mail Merge step) sends each letter as an email to addresses in your data source.

If you choose Edit Individual Documents, Word creates a new file with all the merged letters. Each letter is separated by a page break. You can save this file, print it, or make changes to individual letters before printing. If you choose Print Documents, Word prints everything immediately — make sure your printer is ready.

Save your template for future use

If you plan to send similar letters again, save your main document (the one with merge fields) as a template. Go to File > Save As, choose Word Template (.dotx) as the file type, and give it a clear name like "Personalized Letter Template."

Next time you need to send personalized letters, open this template, update the data source with new names and addresses, and run the merge again. You won't have to rebuild the merge fields or reconnect to your data source — Word remembers the connection.

Frequently Asked Questions

Can I merge to email instead of printing?

Yes. Choose Email Messages in the Start Mail Merge step, then insert a merge field for email addresses. When you click Finish & Merge > Send Email Messages, Word creates individual emails to each address with your letter as the body. You can add a subject line before sending.

What if my data source has blank cells?

Word inserts nothing where the cell is blank — the merge field simply disappears. If you're merging addresses and someone has no middle name, the middle name field will be empty, which is usually fine. If blank cells cause formatting problems, you can edit individual documents after merging to clean them up.

Can I merge only some of the records, not all of them?

Yes. After connecting to your data source, click Select Recipients > Refine Recipient List. You can uncheck specific names or filter by criteria (for example, merge only people in a certain state). Only checked records will be included in the merge.

How do I fix merge fields that show the wrong information?

Check that your data source column headers match exactly what you typed in the merge field. If your column is named "FirstName" but you inserted a field called "First_Name," Word won't find it. Go back to Preview Results, turn it off, delete the incorrect merge field, and insert the correct one from the dropdown.

Can I use mail merge with labels or envelopes?

Yes. Choose Labels or Envelopes in the Start Mail Merge step. For labels, Word asks which label size you're using (Avery 5160 is common). Insert merge fields for name and address, then finish the merge. Word creates a sheet of labels with each person's information in the right position.