How to Fix Word Mail Merge Address Block Showing Only ZIP Codes
Question details
The user needs to resolve an issue where the Word mail merge Address Block only displays the ZIP code instead of the complete address.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Creating mail merge labels using an external data source where the Address Block is failing to pull all required address fields.
- Observed behavior
- During the mail merge, the Address Block field and the Match Fields list only display the ZIP code data, completely omitting street, city, state, and recipient names.
Ensure you have access to the original Excel or Access database file being used for the mail merge, as the issue may stem from data source configurations.
Use Individual Merge Fields Instead of Address Block
Bypassing the built-in Address Block and inserting individual fields gives you complete control over which data appears on your labels.
The Address Block feature relies on Word automatically identifying your column headers. If the headers differ from Microsoft's standard naming conventions, it often fails to pull the correct data. Using individual merge fields bypasses this automated guessing.
Open your mail merge document in Word and go to the 'Mailings' tab on the top ribbon.
Instead of clicking 'Address Block', click on 'Insert Merge Field'. A dropdown will appear listing all the columns from your data source.
Select each field individually (e.g., First Name, Last Name, Address, City) and insert them into the document. Add manual spaces, commas, and line breaks between the fields to format the address correctly.
Click 'Preview Results' in the Mailings ribbon to verify that the full addresses are now displaying properly.

Verify and Fix the Database Name Manager Configuration
Sometimes the data source is incorrectly scoped to only pull the ZIP code column. Adjusting the named range in Excel fixes this.
Easily Create Mail Merge Labels with WPS Writer
WPS Office offers a straightforward and highly compatible Mail Merge feature, allowing you to seamlessly link Excel data to your documents without encountering complex Address Block errors.
- 1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' tab on the ribbon.
- 2. Connect Data Source: Click 'Mail Merge' to enable the tools, then click 'Open Data Source' to select your Excel address list.
- 3. Insert Custom Fields: Click 'Insert Merge Field' to place your individual data columns precisely where needed in your label document.
- 4. Preview and Print: Click 'View Merged Data' to check your address formatting, then proceed to 'Merge to Printer' or 'Merge to New Document'.

Frequently Asked Questions
Why is my Address Block missing names and street addresses?
Word's Address Block feature tries to automatically match your spreadsheet's column headers to its standard, predefined fields. If your Excel columns use non-standard names (like 'Zip' instead of 'Postal Code' or 'Street' instead of 'Address 1'), Word may fail to map them, resulting in missing data.
How do I manually map fields in a Word mail merge?
You can manually map fields by clicking 'Match Fields' in the Mailings tab. A dialog box will appear allowing you to manually link Word's default address elements to the specific column headers currently used in your data source.
Can I edit the Address Block format directly?
Yes, you can customize the Address Block layout by pressing Alt+F9 to reveal the document's field codes. However, modifying these nested field codes can be complex, making it generally easier and more reliable to use individual 'Insert Merge Field' options for precise formatting.




