Mail merge connects your Excel spreadsheet to a Word document so Word pulls names, addresses, and other details from your sheet and fills them into a template letter or label automatically

Instead of typing each recipient's name and address into separate letters, you create one template in Word, point it to your Excel data, and Word generates a personalized copy for each row. The process has three parts: preparing your Excel list, setting up your Word template, and running the merge. Most people finish in under an hour once they understand the order of steps.

This works in Microsoft Word and Excel on Windows and Mac. Google Docs has a similar feature through add-ons, but the steps differ. This guide covers the Microsoft versions, which are the most common setup.

Key Takeaways

  • Your Excel spreadsheet must have column headers in the first row — "First Name", "Last Name", "Address" — because Word uses these names to find the right data.
  • Word's mail merge wizard walks you through connecting to your Excel file, selecting which rows to use, and inserting merge fields into your template.
  • You can preview how each merged letter will look before you print or save them all at once.
  • Common mistakes include forgetting headers in Excel, leaving blank rows in your data, or inserting merge fields in the wrong spots in your template.

Prepare your Excel spreadsheet with headers and clean data

Open your Excel file and make sure the first row contains column headers. If you are mailing letters, you need columns like "First Name", "Last Name", "Address", "City", "State", "ZIP". If you are creating labels, you might add "Company" or "Title". The exact names do not matter, but they must be in row 1, and Word will use these names to identify which column holds which information.

Check that your data starts in row 2 and has no blank rows in the middle. If row 5 is empty and row 6 has data, Word may stop merging at row 4. Delete any completely empty rows. Save your Excel file before you move to Word — use File > Save or Ctrl+S (Windows) or Command+S (Mac).

If some recipients are missing information — no middle initial, no company name — leave that cell blank rather than typing "N/A" or a dash. Word can handle blank fields and will skip them cleanly in your template.

Open Word and start the mail merge wizard

In Microsoft Word, go to the Mailings tab at the top. Click "Start Mail Merge" and select the type of document you are creating: "Letters" for individual pages, "Labels" for label sheets, "Envelopes" for envelope addresses, or "Directory" for a single document listing all records. For this example, we will use Letters.

After you choose the document type, click "Start Mail Merge" again and select "Step by Step Mail Merge Wizard". A panel will open on the right side of your screen walking you through each step. This wizard is the easiest route for first-time users because it shows you what to do at each stage.

Connect Word to your Excel file

The wizard will ask you to select your data source. Click "Browse" and navigate to your Excel file on your computer. Select it and click Open. Word will then show you a preview of your data — you should see your column headers and the first few rows of recipient information.

If Word asks which sheet to use and your data is on Sheet1, select that. If you have multiple sheets in your workbook, make sure Word is pointing to the one with your recipient list. You can also choose to use only certain rows by clicking "Data Options" and setting a range, but for most jobs you will use all rows.

Insert merge fields into your Word template

Now you write your letter template in Word. Type the body of your letter as you normally would. When you reach a spot where you want to insert data from Excel — usually the recipient's name and address at the top — click "More Items" in the wizard panel. A dialog box will show all your column headers from Excel.

Select "First Name" and click Insert. Word will place a merge field that looks like <<First Name>> into your letter. Do the same for Last Name, Address, City, State, and ZIP, placing them where they belong in your address block. You can type commas, line breaks, and spaces around the merge fields just as you would in a normal letter.

If you want to use a merge field more than once — for example, "Dear <<First Name>>" in the greeting and "Sincerely, <<First Name>>" in the closing — insert it in both places. Word will fill in the same value from Excel each time.

Preview and complete the merge

Before you print or save, click "Preview Results" in the wizard. Word will show you how your first letter will look with actual data from your Excel file. Use the arrow buttons to flip through a few letters and check that the names, addresses, and any other details are in the right places. If something looks wrong — an address field is blank when it should not be, or a name is in the wrong spot — go back and fix your template or your Excel data.

Once the preview looks correct, click "Complete the Merge". You have two options: "Print Documents" will send all letters directly to your printer, or "Edit Individual Documents" will create a new Word document with all merged letters so you can review, edit, or save them before printing. For most jobs, "Edit Individual Documents" is safer because you can spot-check the results and make changes if needed.

Save your merged documents or print them

If you chose "Edit Individual Documents", Word creates a new document with all your merged letters. Each letter starts on a new page. You can now print this document, save it as a PDF, or save it as a Word file. Use File > Save As and choose your format.

If you chose "Print Documents" directly from the wizard, your letters go straight to the printer. You cannot undo this, so make sure your preview looked correct first.

Keep your original template letter and your Excel file. If you need to send the same letters to a different group next month, you can reuse the template and just swap in a new Excel file with different recipients.

Frequently Asked Questions

What if my Excel file has a middle initial column but some rows are blank?

Leave those cells blank in Excel. In your Word template, type the merge field for middle initial between the first and last name fields. When Word merges, it will skip the middle initial for anyone who does not have one, and the spacing will still look correct.

Can I merge only some rows from my Excel file, not all of them?

Yes. In the wizard, click "Data Options" before you insert merge fields. You can set a range — for example, rows 2 through 50 — to merge only those recipients. You can also manually delete rows from your Excel file before you start if you want to exclude certain people.

What if Word cannot find my Excel file?

Make sure the file is saved and closed before you start the mail merge in Word. Word cannot read an Excel file that is currently open. Also check that the file is in a location your computer can access — not on a network drive that has disconnected, and not in a folder that requires a password.

Can I use mail merge to create labels?

Yes. At the start, choose "Labels" instead of "Letters". Word will ask you to select your label template — Avery 5160 is the most common size for address labels. Then insert your merge fields into the label layout, and Word will repeat the label for each row in your Excel file.

How do I fix a merge field that is in the wrong place?

Click on the merge field (it looks like <<Field Name>>) and delete it. Then click "More Items" in the wizard and insert the correct field. You can also cut and paste merge fields to move them around, just like regular text.