Fix Excel Addresses Not Appearing in Word Mail Merge
Question details
The user needs to display address information from an Excel spreadsheet in a Word mail merge document or envelope.

- 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.
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.
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.
Go to the Mailings tab, click 'Select Recipients', and choose 'Use an Existing List' to locate and open your Excel file.
In the Mailings tab, look for the 'Write & Insert Fields' section and click the 'Insert Merge Field' dropdown button.
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.
Click 'Preview Results' in the Mailings tab to verify that the addresses from your Excel list populate correctly into the document.

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. Open Mail Merge: Open your document in WPS Writer, navigate to the 'References' or 'Mailings' tab, and click 'Mail Merge'.
- 2. Open Data Source: Click 'Open Data Source' and select your Excel spreadsheet containing the recipient addresses.
- 3. Insert Merge Field: Place your cursor where the address should go, click 'Insert Merge Field', and select the corresponding columns.
- 4. Merge to New Document: Click 'Merge to Different New Document' to generate your final letters or envelopes with the inserted data.

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.




