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

A mail merge takes a list of names, addresses, or other information from Excel and automatically fills those details into a Word document template. Instead of typing each person's name and address into 50 different letters, you create one letter template with blank spots, point Word to your Excel list, and Word generates 50 complete letters in seconds — one for each row in your spreadsheet.

The most common use is sending personalized letters or emails to many people at once. You might also use it to create name badges, mailing labels, or form letters where only a few details change between copies. The Excel file holds the data (the list), and the Word document holds the layout and text (the 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.
  • In Word, you insert merge fields (placeholders like <<FirstName>>) into your template document where you want the Excel data to appear.
  • The mail merge process in Word walks you through selecting your Excel file, choosing which records to use, and previewing the results before you finish.
  • You can merge to a new document (creating all letters at once) or directly to your printer or email, depending on what you need to do next.

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 categories your data falls into. If you're merging names and addresses, your headers might be FirstName, LastName, Address, City, State, ZipCode. Each column holds one type of information, and each row below the headers is one person's complete record.

Make sure there are no blank rows in the middle of your data, and remove any extra blank columns on the right side. Word reads from the first row of headers straight down, so gaps or clutter can confuse it. Save your Excel file before you start the merge in Word — you don't need to close it, but it should be saved to disk.

Creating your Word template and inserting merge fields

Open Word and create your letter, label, or document exactly as you want it to look. Type all the text that stays the same for every copy. When you reach a spot where you want Excel data to appear — like where a person's name goes — you'll insert a merge field instead of typing a name.

To insert a merge field in Word, go to the Mailings tab at the top. Click Insert Merge Field and a dropdown list appears showing all the column headers from your Excel file. Click the header you want — for example, "FirstName" — and Word inserts a placeholder like <<FirstName>> into your document. Type normally around it. If you need the last name next, click Insert Merge Field again and choose "LastName". The document now has a mix of regular text and merge fields.

Connecting Word to your Excel file

With your template ready, stay on the Mailings tab and click Start Mail Merge. A menu appears asking what type of document you're creating — choose Letters for a standard letter, Labels for mailing labels, Envelopes for envelopes, or Directory for a list where all records appear in one document.

Next, click Select Recipients and choose Use an Existing List. A file browser opens. Navigate to your Excel file and click it to open. Word may ask which sheet you want to use (if your Excel file has multiple sheets) and whether the first row contains headers — answer yes to headers. Word now knows where your data is and which columns to use.

Previewing and finishing the merge

Before you create all the documents, preview what they'll look like. Click Preview Results on the Mailings tab. The merge fields in your template disappear and are replaced with actual data from your Excel file — you'll see the first person's information filled in. Use the arrow buttons to scroll through and check that the data looks right and is going into the correct spots.

If something is wrong — a merge field is in the wrong place, or the data doesn't look right — click Preview Results again to turn off the preview, fix your template, and preview again. Once everything looks correct, click Finish & Merge. You have three options: Edit Individual Documents (creates one new Word file with all the merged letters, which you can then edit or print), Print Documents (sends them straight to your printer), or Send Email Messages (if you're doing an email merge).

Choosing where your merged documents go

If you click Edit Individual Documents, Word creates a new document containing every merged letter, one after another. You can then scroll through, make changes to individual letters if needed, and save or print from there. This option gives you the most control and lets you review everything before printing.

If you click Print Documents, Word sends all the merged letters directly to your printer without creating a new file. This is fastest if you're certain everything is correct and you just need printed copies. If you click Send Email Messages, Word uses an email field from your Excel file (like an "Email" column) to send each person their own personalized message — useful for bulk emails where each recipient sees their own name.

Troubleshooting common problems

If Word can't find your Excel file, make sure the file is saved and closed (or at least saved — you don't have to close it). If the merge fields show as <<FieldName>> instead of actual data, you're in preview mode — click Preview Results to turn it off and see the real data. If the data looks jumbled or in the wrong order, check that your Excel column headers match exactly what you typed in the merge fields (they're case-sensitive in some cases, so "FirstName" and "firstname" may not match).

If you see blank spaces where data should be, a column in your Excel file might be empty for some rows, or the header name doesn't match. Go back to your Excel file, verify the headers are spelled correctly, and make sure every row has data in the columns you're using. Save the file again and reconnect it in Word by clicking Select Recipients and choosing your file once more.

Frequently Asked Questions

Can I merge data from a Google Sheet instead of Excel?

Yes. read your Google Sheet as an Excel file (.xlsx), save it to your computer, and follow the same steps. Alternatively, some versions of Word can connect directly to Google Sheets through the Select Recipients menu, though this varies by Word version and your Microsoft account setup.

What if I only want to merge some rows from my Excel file, not all of them?

After you connect to your Excel file, click Edit Recipient List on the Mailings tab. A window opens showing all your records. Uncheck the boxes next to any rows you don't want to merge. Only the checked rows will be included when you finish the merge.

Can I merge to email instead of printing letters?

Yes, if your Excel file has an email column. Create your template in Word, insert merge fields as usual, then click Finish & Merge and choose Send Email Messages. Word will send each person an email with their personalized content. You'll need to specify which column contains the email addresses.

Do I have to create a new Word document each time I want to do a merge?

No. Save your template document after you've set it up. The next time you need to merge the same template with updated data, open the template, go to Mailings, and select your updated Excel file. Word remembers the merge fields you created.

What happens if my Excel file has special characters or accents in names?

Word handles accented characters and special characters correctly in most cases. If the merged document shows strange symbols instead of the correct characters, check that your Excel file is saved as .xlsx (not .xls or .csv) and that the column is formatted as text, not a number or date.