Mail merge pulls data from Excel into Word documents automatically

A mail merge takes information stored in an Excel spreadsheet — names, addresses, email addresses, amounts — and inserts it into a Word document template. Instead of typing each recipient's details by hand, you set up the merge once and Word generates personalized copies for every row in your spreadsheet. The result is a stack of letters, envelopes, or emails that look individually written but were created in minutes.

The process works in three parts: an Excel file with your data, a Word document with placeholders for that data, and Word's mail merge tool that connects them. You do not need any add-ons or special software — both tools have this built in.

Key Takeaways

  • Your Excel file needs column headers in the first row (like "First Name", "Last Name", "Address") and one row of data per recipient.
  • In Word, you insert merge fields where you want the data to appear — Word replaces these fields with actual names and addresses when you run the merge.
  • Word's mail merge wizard walks you through selecting your Excel file, choosing which fields to insert, and previewing results before you finish.
  • The merge creates a new Word document with one copy per row in your Excel file, which you can then print, save, or send.

Prepare your Excel file with headers and clean data

Start by opening the Excel spreadsheet that holds your recipient information. The first row must contain column headers — these are the labels Word uses to identify which data goes where. Common headers are "First Name", "Last Name", "Email Address", "Company", "Address", "City", "State", "Zip Code". Each column should hold one type of information, and each row below the headers should be one recipient.

Check that your data is clean before you merge. Remove extra spaces at the beginning or end of cells, fix obvious typos, and make sure every row has the same number of columns. If a recipient is missing information in one column (like no middle name), leave that cell blank rather than deleting it — blank cells are fine, but missing columns will break the merge. Save the Excel file when you are done.

Open Word and start the mail merge wizard

In Microsoft Word, go to the Mailings tab at the top of the screen. Click Start Mail Merge, then select Step by Step Mail Merge Wizard from the dropdown. This opens a panel on the right side of your screen that guides you through the process.

The wizard asks what type of document you are creating — letters, email messages, envelopes, or labels. Choose the option that matches what you want to send. For a standard letter or email, select Letters. Click Next to move to the next step.

Connect Word to your Excel file

The wizard now asks you to choose a starting document. If you already have a template open in Word (a letter with placeholders where names and addresses should go), select Use the current document. If you are starting fresh, select Start from a template or Start from existing document and open your template file. Click Next.

The wizard then asks you to select recipients. Click Browse and navigate to your Excel file. Select it and click Open. Word may ask which sheet you want to use if your file has multiple sheets — choose the one with your data. A dialog box appears showing a preview of your data. Make sure the headers are correct and the data looks right, then click OK.

Insert merge fields where data should appear

You are now back in your Word document. This is where you place the merge fields — the placeholders that Word will replace with actual data. Click in the document where you want the first name to appear. In the wizard panel on the right, click More items (or in the Mailings tab, click Insert Merge Field). A list of your Excel column headers appears. Click the header you want — for example, "First Name" — and Word inserts a merge field that looks like <<First Name>>.

Repeat this for every piece of information you want to include. If you are writing a letter, you might insert <<First Name>> in the greeting, then <<Address>>, <<City>>, <<State>>, and <<Zip Code>> in the address block. You can type regular text around the merge fields — "Dear <<First Name>>," is perfectly fine. Word will replace only the merge fields, leaving the rest of your text unchanged.

Preview and complete the merge

Before you finish, preview what the merged documents will look like. In the wizard panel, click Preview your letters (or in the Mailings tab, click Preview Results). Word shows you the first recipient's version of the letter with actual data instead of merge fields. Use the arrow buttons to scroll through a few examples and make sure everything looks correct — names are spelled right, addresses are in the right place, and no merge fields are left unfilled.

If something is wrong, click Back to return to the previous step and fix it. Once you are satisfied, click Complete the merge in the wizard panel. Word asks whether you want to print the documents, send them as email, or edit individual letters. Choose Edit individual letters to create a new Word document with all the merged copies. You can then save this document, print it, or make changes to individual letters before sending.

Common problems and how to fix them

If a merge field shows the column header name instead of actual data — for example, you see "<<First Name>>" instead of "John" — Word is showing field codes instead of results. Press Ctrl+A to select all, then press Ctrl+Shift+9 to toggle field codes off and show the actual data.

If some recipients are missing from the merge, check your Excel file to make sure every row has data and no rows are completely blank. If a merge field is blank for some recipients, that is normal — it means that recipient had no data in that column. If you want to skip certain recipients, you can filter the data before merging by clicking Edit recipient list in the Mailings tab and unchecking the rows you do not want.

Frequently Asked Questions

Can I merge to email instead of printing letters?

Yes. In the mail merge wizard, select Email messages as your document type instead of Letters. Set up your merge fields the same way, then when you complete the merge, choose Send email messages. Word will open your email program and create one message per recipient with the merge fields filled in.

What if my Excel file has more columns than I need?

That is fine. You only insert merge fields for the columns you actually want to use. Extra columns in your Excel file are ignored. You can also delete columns from your Excel file before merging if you want to clean it up.

Can I edit individual letters after the merge is complete?

Yes. When you choose Edit individual letters at the end, Word creates a new document with all the merged copies. You can then edit any letter by hand, delete copies you do not need, or change formatting. The original template and Excel file are not affected.

Do I have to use the mail merge wizard, or can I do it without the step-by-step guide?

You can skip the wizard and use the individual buttons in the Mailings tab instead — Select Recipients, Insert Merge Field, and Finish & Merge. The result is the same, but the wizard is usually easier for first-time users because it shows you what to do next.