Document Editing Problems

Fix Excel Addresses Not Appearing in Word Mail Merge

John WilsonJohn Wilson Oct 29, 2026 871 views

Question details

The user needs to display address information from an Excel spreadsheet in a Word mail merge document or envelope.

How to Fix Excel Addresses Not Appearing in a Word Mail Merge
Product
Word
Device & OS
not provided
Scenario
Creating an envelope or document using Mail Merge with an Excel recipient list.
Observed behavior
Address information from the Excel file does not automatically populate in the Word document after selecting the recipients.
Before you start

Ensure your Excel spreadsheet has clear column headers (such as Name, Address, City, State, and Zip Code) and is saved and closed before starting the mail merge.

Solution 1Recommended

Insert Merge Fields Manually

Address fields must be manually mapped and inserted into the document so the program knows exactly where to place the Excel data.

When you link an Excel spreadsheet to a Word mail merge, the software does not automatically guess where your data should go. You must explicitly define which columns correspond to which parts of your document by inserting Merge Fields into the text area.

1
Select Recipients

Go to the Mailings tab, click 'Select Recipients', and choose 'Use an Existing List' to locate and open your Excel file.

2
Access the Merge Fields

In the Mailings tab, look for the 'Write & Insert Fields' section and click the 'Insert Merge Field' dropdown button.

3
Add Address Components

Select the required fields from your Excel columns (such as Name, Address, City, State, and Postal Code) and insert them onto your envelope or document layout.

4
Preview Results

Click 'Preview Results' in the Mailings tab to verify that the addresses from your Excel list populate correctly into the document.

Insert Merge Fields Manually
Formatting Tip: Make sure to add appropriate spacing and punctuation (like a space or comma between City and State) between your inserted merge fields, as Word will not add these automatically.
WPS Office Writer

Easily Perform Mail Merge with WPS Office

WPS Writer provides an intuitive and seamless Mail Merge feature, making it simple to create bulk envelopes, letters, and labels with complete control over your data fields.

  1. 1. Open Mail Merge: Open your document in WPS Writer, navigate to the 'References' or 'Mailings' tab, and click 'Mail Merge'.
  2. 2. Open Data Source: Click 'Open Data Source' and select your Excel spreadsheet containing the recipient addresses.
  3. 3. Insert Merge Field: Place your cursor where the address should go, click 'Insert Merge Field', and select the corresponding columns.
  4. 4. Merge to New Document: Click 'Merge to Different New Document' to generate your final letters or envelopes with the inserted data.
Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Intuitive Mailings ribbon for easy recipient selection and field insertion.Free, lightweight, and fast alternative to Microsoft Office.Cross-platform support for seamless document and spreadsheet editing.
microsoft office alternative - wps office

Frequently Asked Questions

Why are my Excel zip codes dropping the leading zero in Word mail merge?

Word often interprets zip codes as numeric values, causing it to drop leading zeros. To fix this, open your Excel spreadsheet and format the zip code column as 'Text' before performing the mail merge.

Can I use an Address Block instead of inserting individual merge fields?

Yes, the 'Address Block' feature attempts to map your Excel columns automatically to create a standard address layout. However, if your column headers in Excel don't match standard names, you may need to click 'Match Fields' to manually assign them.

Why is the 'Insert Merge Field' button grayed out?

The 'Insert Merge Field' button remains disabled until you successfully link a data source. Ensure you have clicked 'Select Recipients' and properly loaded your Excel spreadsheet first.