Mail Merge from Excel: How to Prepare Your List (No Errors)
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.
Clean your mailing list with the free tools
- Clean Whitespace: removes hidden spaces.
- Fix Text Case: turns JOHN SMITH into John Smith.
- Merge Columns: puts first and last name in one column.
- Format US Addresses: brings US addresses into one format.
- Find and Remove Duplicates: so nobody gets the same letter twice.
Every tool runs on your own computer. Your original file stays as it is.
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.
Run the mail merge in Word, step by step
- In Word, go to Mailings, Start Mail Merge, Letters.
- Click Select Recipients, Use an Existing List. Choose your Excel file.
- Click Insert Merge Field and add the name and address fields.
- Click Preview Results and check a few letters.
- 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 Excel | After cleaning |
|---|---|
| JOHN MCDONALD | John McDonald |
| "Boston " with a space | Boston |
| 2110 | 02110 |
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
How to Keep Leading Zeros in Excel (ZIP Codes and IDs)
Excel turns 02110 into 2110. Here is how to get the zero back.
Remove Duplicates in Excel Without Losing Data (3 Ways)
Find double rows and remove them, without deleting the wrong ones.
How to Convert Text to Date in Excel (Dates Not Sorting)
Your dates do not sort? They are text. Here is how to turn them into real dates.