Excel guide

Mail Merge from Excel: How to Prepare Your List (No Errors)

Last updated: October 10, 2026 · 4 min read

A mail merge puts names and addresses from your Excel list into a Word letter. Most problems do not come from Word. They come from the Excel list. Here is how to prepare your list in three steps. Start with Fix 1.

Fix 1

Clean your mailing list with the free tools

Every tool runs on your own computer. Your original file stays as it is.

Fix 2

Set up your Excel list for the mail merge

  • One header row on top. The headers become the fields in Word, like FirstName and LastName.
  • Keep your data on the first worksheet. It is the easiest way.
  • Format the ZIP code column as Text. Otherwise Word drops zeros, and 00399 becomes 399.
  • Add dollar signs in the Word letter, not in Excel.
  • Close the file before you start in Word. This avoids lock problems.

More on zeros in our guide on leading zeros in Excel.

Fix 3

Run the mail merge in Word, step by step

  1. In Word, go to Mailings, Start Mail Merge, Letters.
  2. Click Select Recipients, Use an Existing List. Choose your Excel file.
  3. Click Insert Merge Field and add the name and address fields.
  4. Click Preview Results and check a few letters.
  5. Click Finish and Merge.

Word may use other names for the buttons in other languages. The order stays the same.

Mail merge problems and how to fix them

  • ZIP codes lose the zero: format the ZIP column as Text in Excel.
  • Dates look wrong: if your dates are text, see our guide on text to date. To change the style, add a date switch to the field in Word, like the one below.
  • Names in capitals: run the Fix Text Case tool before you start.
{ MERGEFIELD OrderDate \@ "MMMM d, yyyy" }

This shows the date like March 4, 2026. To add the switch, right click the field in Word, choose Toggle Field Codes and type the switch after the field name.

Mail merge from Excel: before and after

Before in ExcelAfter cleaning
JOHN MCDONALDJohn McDonald
"Boston " with a spaceBoston
211002110

Clean data in Excel means clean letters in Word.

Get your list ready for the mail merge

These free tools run on your own computer. Your list is never uploaded.

Questions about mail merge from Excel

Why are the leading zeros missing in my mail merge?

The ZIP code column is formatted as a number. Format it as Text in Excel before you connect the file with Word.

Do I need separate columns for first and last name?

Yes, if you want a greeting with the first name only. If you also need the full name in one column, the Merge Columns tool does that without formulas.

Where do I add a dollar sign?

In the Word letter, before or after the merge field. Do not add it in Excel.

Can I use a CSV file for a mail merge?

Open it in Excel first and set the ZIP column to Text, then save it as an Excel file. Use that file for the merge.

More Excel guides

← All Excel guides