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

A mail merge takes a list of names, addresses, or other information stored in Excel and automatically fills that data into a Word document template. Instead of typing each person's name and address into separate letters by hand, you create one letter with blanks, point Word to your Excel file, and Word fills in the blanks for every row in your spreadsheet. You end up with dozens or hundreds of personalized documents in minutes.

The most common use is sending form letters — the same letter to many people, but with each person's name, address, and details filled in. You might also use it to create name badges, mailing labels, envelopes, or email messages. The Excel file is your data source, and the Word document is your template.

Key Takeaways

  • Your Excel file must have column headers in the first row — names like "FirstName", "LastName", "Address" — so Word knows which data goes where.
  • The Word document is where you write the letter or template once, then mark the spots where Excel data should appear using merge fields.
  • Word's Mail Merge wizard walks you through connecting to your Excel file, choosing which rows to use, and previewing the results before you finish.
  • The final step produces either separate documents you can save and print, or a single document with all merged results stacked together.

Setting up your Excel file correctly

Before you open Word, prepare your Excel spreadsheet. The first row must contain column headers — the names of the data categories. If you're merging names and addresses, your headers might be FirstName, LastName, Street, City, State, Zip. Each column header becomes a merge field that Word can insert into your template.

Put one person's information in each row below the headers. Make sure there are no blank rows in the middle of your data — if Word encounters a blank row, it may stop reading the file. Save your Excel file before you start the merge process in Word; Word needs to read a saved file, not one that's still open and unsaved.

Check that your data is clean: no extra spaces before or after names, consistent formatting in address fields, and no special characters that might cause problems. If you're merging email addresses, make sure they're in their own column with a clear header like "Email".

Creating your Word template with merge fields

Open a new Word document and write the letter, label, or document you want to repeat. Where you want Excel data to appear, you'll insert a merge field — a placeholder that tells Word "put the FirstName data here" or "put the Address data here".

To insert a merge field in Word, go to the Mailings tab at the top of the screen. Click Insert Merge Field and a dropdown menu appears showing all the column headers from your Excel file. Click the header you want — for example, "FirstName" — and Word inserts it into your document surrounded by angle brackets, like this: <<FirstName>>. Type the rest of your letter around these fields.

A typical letter might look like this: "Dear <<FirstName>> <<LastName>>, Thank you for your order. We will ship to <<Street>>, <<City>>, <<State>> <<Zip>>." When the merge runs, Word replaces each <<FieldName>> with the actual data from that row in Excel.

Connecting Word to your Excel file

With your template open in Word, go to the Mailings tab and click Start Mail Merge. A menu appears asking what type of document you're creating — choose Letters for a standard mail merge (or choose Labels, Envelopes, or Email Messages if that's what you're doing).

Next, click Select Recipients and choose Use an Existing List. A file browser opens. Navigate to your Excel file and open it. Word may ask which sheet you want to use if your workbook has multiple sheets — choose the one with your data. Word then confirms the column headers it found and shows you a preview of the first few rows.

If the preview looks correct, click OK. Word is now connected to your Excel data. You can see the merge fields in your template, and Word knows where to pull the information from.

Previewing and finishing the merge

Before you create all the merged documents, preview what they'll look like. Still in the Mailings tab, click Preview Results. Your template now shows real data from the first row of your Excel file instead of the merge field names. Use the arrow buttons to flip through and see how the second, third, and fourth rows will look. This is your chance to catch mistakes — if a name looks wrong or an address is formatted oddly, go back to Excel, fix it, save the file, and refresh Word's preview.

Once the preview looks right, click Finish & Merge. You have three options: Edit Individual Documents (creates one big Word file with all merged results, one after another, so you can edit any of them before printing), Print Documents (sends them straight to your printer), or Send Email Messages (if you set up an email merge, this sends them out).

For most people, Edit Individual Documents is the safest choice. It creates a new Word document with all your merged letters. You can review them, make changes if needed, and then save or print. The original template stays unchanged, so you can run the merge again later with different data if you need to.

Troubleshooting common problems

If Word can't find your Excel file, make sure it's saved and closed before you start the merge. Word reads saved files, not files that are currently open in Excel. If you moved or renamed the file after starting the merge, Word loses the connection — you'll need to click Select Recipients again and point to the new location.

If merge fields aren't showing up in your template, you may have typed them by hand instead of inserting them through the Insert Merge Field button. Delete what you typed and use the button instead — Word needs to recognize them as actual merge fields, not just text that looks like merge fields.

If the merged data looks misaligned or has extra spaces, the problem is usually in your Excel file. Check for leading or trailing spaces in your cells (spaces before or after the actual data), and make sure all rows have data in every column — blank cells can throw off formatting. Fix it in Excel, save, and refresh the preview in Word.

Frequently Asked Questions

Can I merge to email instead of printing letters?

Yes. Set up your merge the same way, but when you click Start Mail Merge, choose Email Messages instead of Letters. Your Excel file needs an "Email" column with email addresses. When you finish, choose Send Email Messages and Word sends the merged message to each address.

What if I only want to merge some rows, not all of them?

After you connect to your Excel file, click Edit Recipient List in the Mailings tab. A window opens showing all your data. Uncheck the rows you don't want to include in the merge. Only the checked rows will be merged into documents.

Can I use data from multiple Excel sheets at once?

No. A mail merge pulls from one sheet at a time. If your data is split across sheets, combine it into a single sheet in Excel first, then run the merge.

Do I need to keep the Excel file after the merge is done?

You don't need it to print or send the merged documents. But if you save the Word template with the merge fields still in it, you can run the merge again later with updated Excel data. If you delete the Excel file and later try to refresh the merge, Word won't be able to find the data source.

What happens if I edit the merged document after the merge is complete?

Once the merge is done and you have a new document with all the results, it's just a regular Word document. You can edit any letter individually. The merge fields are gone — they've been replaced with actual text. Changes you make won't affect the template or the original Excel data.