Formatting Issues

How to Remove the Comma from Word Mail Merge Addresses

Anum MushtaqAnum Mushtaq Nov 3, 2026 872 views

Question details

The user wants to remove the automatic comma inserted between the city and state fields during a mail merge.

How to Remove the Comma from Word Mail Merge Addresses
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.
Before you start

Ensure your Excel data source separates the address components (street, city, state, zip) into distinct columns so you can map them individually.

Solution 1Recommended

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.

1
Delete the Address Block

Highlight and delete the existing <<Address Block>> field from your main document or the first label in your template.

2
Insert individual merge fields

Navigate to the Mailings tab, click 'Insert Merge Field', and sequentially add your Address, City, State, and Postal Code fields.

3
Format without the comma

Arrange the inserted fields on the page exactly as required, pressing the spacebar between <<City>> and <<State>> instead of typing a comma.

4
Propagate the format to all labels

If you are printing labels, click the 'Update Labels' button on the Mailings tab to apply this new layout to the entire sheet.

Postal Standards: A comma between the city and state is conventional and does not invalidate the address. Postal systems deliver bulk mail efficiently with or without commas.
Advanced Mail Merge in WPS Office

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. 1. Open WPS Writer: Launch WPS Writer and open your main document or address label template.
  2. 2. Connect your Data Source: Go to the Mailings tab, click 'Open Data Source', and select your Excel address list.
  3. 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. 4. Merge to Document: Click 'Merge to New Document' or 'Merge to Printer' to finalize and print your perfectly formatted addresses.
Precise control over address layouts and punctuationFully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsLightweight, fast, and completely free to useIntuitive Mailings tab interface for quick setup
microsoft office alternative - wps office

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.