How to Remove the Comma from Word Mail Merge Addresses
Question details
The user wants to remove the automatic comma inserted between the city and state fields during a mail merge.

- Product
- Word
- Device & OS
- not provided
- Scenario
- Setting up address labels or letters using the Mail Merge feature.
- Observed behavior
- Word's predefined Address Block automatically inserts a comma between the city and state. This comma is part of the internal formatting of the Address Block and is not sourced from the Excel data file.
Ensure your Excel data source separates the address components (street, city, state, zip) into distinct columns so you can map them individually.
Replace Address Block with Individual Merge Fields
Instead of using the preset Address Block, manually insert individual merge fields to gain complete control over punctuation and spacing.
Because the comma is hardcoded into Word's default Address Block formatting, it cannot be toggled off in the field options. The most reliable solution is to construct the address layout yourself.
Highlight and delete the existing <<Address Block>> field from your main document or the first label in your template.
Navigate to the Mailings tab, click 'Insert Merge Field', and sequentially add your Address, City, State, and Postal Code fields.
Arrange the inserted fields on the page exactly as required, pressing the spacebar between <<City>> and <<State>> instead of typing a comma.
If you are printing labels, click the 'Update Labels' button on the Mailings tab to apply this new layout to the entire sheet.
Perform Flawless Mail Merges Using WPS Writer
WPS Office provides an intuitive Mail Merge feature that gives you total control over field placement and formatting. Easily merge Excel data sources into letters or labels without hidden punctuation.
- 1. Open WPS Writer: Launch WPS Writer and open your main document or address label template.
- 2. Connect your Data Source: Go to the Mailings tab, click 'Open Data Source', and select your Excel address list.
- 3. Insert Merge Fields manually: Use 'Insert Merge Field' to place your City, State, and Zip code fields exactly where needed, leaving just a space between the city and state.
- 4. Merge to Document: Click 'Merge to New Document' or 'Merge to Printer' to finalize and print your perfectly formatted addresses.

Frequently Asked Questions
Does removing the comma affect bulk mail delivery?
No. Removing the comma between the city and state will not invalidate the address. Postal services commonly process bulk mail effectively with or without commas.
Why can't I edit the comma inside the Address Block directly?
The Address Block is a composite field with built-in layout rules. It automatically generates conventional punctuation that cannot be edited or removed directly through standard settings.
How do I apply my new manual address layout to a whole sheet of labels?
Once you have inserted and formatted the individual merge fields on your first label, simply click the 'Update Labels' command on the Mailings tab. This will instantly copy your custom layout to every label on the page.




