Replace Multiple Mail Merge Fields with One Field in Word
Question details
Replace the Pref_City, Pref_State, and Pref_Zip mail merge fields with a single CityStZip field.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- A Word mail merge document uses three individual fields for a city, state, and ZIP code, and the user wants to insert one combined field instead.
- Observed behavior
- The desired result is one CityStZip merge field that displays the combined address components.
Check that you can edit the mail merge data source and that its city, state, and ZIP columns contain the intended values. If ZIP codes have leading zeros, store them as text before combining them.
Add a combined field to the data source and insert it in Word
Use this approach to replace the three fields without writing a macro.
In the data source, add a column named CityStZip. For example, in an Excel table, enter =[@Pref_City]&", "&[@Pref_State]&" "&[@Pref_Zip] and fill it down if needed.
Save the data source. In Word, open Mailings > Select Recipients > Use an Existing List and select the updated source if CityStZip is not available in the field list.
In the document, select the three merge fields and any separators between them. Delete the selection, then choose Mailings > Insert Merge Field > CityStZip. Repeat at other locations where the fields appear together.
Choose Mailings > Preview Results and browse several recipients to check the punctuation, spacing, and ZIP codes.

Use a Word VBA macro to insert the combined field
Use this option when you want a reusable command to replace a selected group of fields.
Work with mail merge documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format support helps you move existing files between suites; it does not fix Word-specific VBA behavior.

Frequently Asked Questions
Why doesn't CityStZip appear in Insert Merge Field?
Confirm that CityStZip is a column header in the saved data source. If it still does not appear, reconnect the file through Mailings > Select Recipients > Use an Existing List.
Will the macro replace every group of fields in the document?
No. The macro replaces the current selection only. Select each group of fields and its separators, then run the macro again.
How can I keep leading zeros in ZIP codes?
Store ZIP codes as text in the data source before creating CityStZip. Then use Mailings > Preview Results in Word to check the merged values.
Can I use AutoText instead of a combined data field?
Yes. You can store an AutoText entry containing the three merge fields and their formatting in a template accessible to your macro. This reuses the group but does not turn it into a single CityStZip field.




