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

Mail merge saves you from typing the same letter fifty times with different names. You create one template in Word, point it to your Excel file, and Word generates a separate letter for each row in your spreadsheet. The process works in three steps: prepare your Excel data, set up your Word template, and run the merge.

The result is a stack of personalized documents — one per person in your list. You can print them, save them as individual files, or send them directly to email addresses in your spreadsheet. Most people use mail merge for bulk letters, invoices, or form emails where the body stays the same but recipient details change.

Key Takeaways

  • Your Excel file needs a header row with column names like "FirstName", "LastName", and "Email" — Word uses these names to know which data goes where.
  • In Word, you insert merge fields (like <<FirstName>>) into your template letter wherever you want Excel data to appear.
  • Word's Mail Merge Wizard walks you through selecting your Excel file, choosing which records to merge, and previewing the results before you finish.
  • You can merge to a new document (creates one file with all letters), print directly, or send emails if your Excel file has an email column.

Prepare your Excel spreadsheet with the right structure

Open your Excel file and make sure the first row contains column headers — these are the names Word will recognize. Common headers are FirstName, LastName, Address, City, State, ZipCode, Email, and Company. Each row below the header is one person who will receive a merged document.

Check that your data is clean: no blank rows in the middle of your list, no extra spaces before or after names, and consistent formatting in each column. If your list has 200 people but row 50 is blank, the merge will stop or skip records. Save your Excel file when you are done — you will point Word to this file during the merge.

Create your Word template with merge fields

Open a new Word document and write the letter or form you want to send. Type the body text exactly as it should appear in every merged document. Wherever you need data from Excel to appear — like a person's name or address — you will insert a merge field instead of typing it.

To insert a merge field, go to the Mailings tab in Word, click Insert Merge Field, and select the column name from your Excel header row. Word inserts it as <<FirstName>> or <<LastName>>. For example, your letter might say "Dear <<FirstName>> <<LastName>>," and Word will replace that with "Dear John Smith," in the first merged letter, "Dear Maria Garcia," in the second, and so on.

Format your template the way you want the final letters to look — add your letterhead, adjust margins, choose fonts. Everything except the merge fields will be identical in every merged document. Save this template with a clear name like "MergeTemplate_Invoice" so you can find it later.

Connect Word to your Excel file using the Mail Merge Wizard

With your template open in Word, go to the Mailings tab and click Start Mail Merge. Choose Step-by-Step Mail Merge Wizard (or Mail Merge Wizard depending on your Word version). The wizard opens a panel on the right side of your screen.

In Step 1, select Letters as your document type. In Step 2, choose Use the current document since you already have your template open. In Step 3, click Browse and navigate to your Excel file. Word will ask which sheet to use if your file has multiple sheets — select the one with your data. Word then reads your header row and confirms it found the merge fields in your template.

Step 4 lets you preview how the merged letters will look. Scroll through a few examples to make sure names and addresses are appearing in the right places. If something looks wrong, go back and check your Excel data or your merge field placement in the template.

Complete the merge and choose your output format

In the final step, you choose what to do with the merged documents. The three main options are: merge to a new document (creates one Word file containing all letters, one per page), print directly to your printer, or send as email.

If you choose Merge to New Document, Word creates a single file with all your merged letters. You can then print this file, save it, or edit individual letters if needed. If you choose Print, Word sends each merged letter directly to your printer without creating a file first — useful if you only need paper copies. If you choose Send Email, Word uses an email column from your Excel file (like a column named "Email") to send each letter as the body of an email to that address.

Click Merge or Complete the Merge depending on your Word version. Word processes each row in your Excel file and generates the output you selected. If you merged to a new document, save it with a name like "MergedLetters_2024" so you have a record of what you sent.

Troubleshoot common mail merge problems

If merge fields show as <<FieldName>> instead of actual data in your final document, right-click the field and select Update Field. If the merge skips records or stops partway through, check your Excel file for blank rows or inconsistent data in the column headers. Delete any blank rows and make sure every header is spelled exactly the same way in every row.

If Word cannot find your Excel file, make sure the file is saved and closed before you start the merge. Word needs the file to be closed so it can read it without conflicts. If you moved or renamed your Excel file after starting the merge, Word will ask you to locate it again — click Browse and navigate to the new location.

If email merge is not working, confirm that your Excel file has a column with the header "Email" (or whatever you named it) and that every row has a valid email address. Word will skip rows with blank email cells. Also check that your email column contains only email addresses, not names or other text mixed in.

Frequently Asked Questions

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

Yes. In the Mail Merge Wizard, Step 4 shows a list of all records. Uncheck the box next to any row you want to skip, and Word will not merge that record. You can also filter by criteria — for example, merge only people in a certain state — by clicking Filter in the wizard and setting conditions.

What if I need to send emails but my Excel file has the email addresses in a column with a different name?

Rename the column header in Excel to "Email" before you start the merge. Word looks for a column specifically named "Email" when you choose the email merge option. Save your Excel file after renaming the column and then start the merge again.

Can I edit individual merged letters after the merge is complete?

Yes, if you merged to a new document. Open the merged file and edit any letter the same way you would edit a regular Word document. Each letter is separated by a page break, so you can find the one you need and make changes. If you need to change something in all letters, edit your template and run the merge again.

Do I need to keep my Excel file open while I run the mail merge?

No. Close your Excel file before you start the merge. Word reads the data from the saved file, so it does not need the file to be open. If you leave it open, Word may have trouble accessing the data or ask you to close it.

What happens if my Excel file has special characters or accented letters?

Mail merge handles accented letters and special characters correctly as long as your Excel file is saved in a standard format like .xlsx. If characters appear garbled in the merged document, save your Excel file as .csv (comma-separated values) instead and try the merge again.