How to Fix Duplicate City Fields in Word Mail Merge Labels
Question details
The user needs to remove duplicate city fields that are appearing on both the first line and the address line of mail merge labels.
- Product
- Word, Excel
- Device & OS
- not provided
- Scenario
- Generating mailing labels using Word's mail merge feature with an Excel address list as the data source.
- Observed behavior
- The city name repeats incorrectly on the recipient's first line and the designated address line, indicating either an extra inserted field or poorly structured source columns.
Before editing your mail merge fields, preview your results to pinpoint exactly which label templates are affected, and verify your Excel file is closed to avoid read-only errors during the merge.
Remove the Extra Merge Field and Update Labels
Delete the duplicated city field from the primary label cell and synchronize the layout across all labels.
A Word mail merge creates a table using the first cell as a master template for the rest. If an extra merge field is accidentally inserted into this first cell, the error will duplicate across the entire document.
Open your Word mail merge document and navigate to the very first label cell, typically located in the top-left corner of the page.
Look for the extra '<<City>>' merge field on the first line. Highlight the field, including its angle brackets, and press the Delete or Backspace key.
Navigate to the 'Mailings' tab on the top ribbon. In the 'Write & Insert Fields' group, click the 'Update Labels' button. This will apply the corrected layout to every other label on the page.
Click the 'Preview Results' button on the Mailings tab to confirm that the duplicate city name has been successfully removed from all addresses.
Separate Combined Data Columns in Excel
Ensure your Excel address list is properly formatted with distinct columns so data doesn't merge incorrectly.
Create Error-Free Mail Merge Labels with WPS Writer
WPS Office provides a highly intuitive and visually streamlined Mail Merge feature. It seamlessly handles Excel address lists to help you generate accurate, professionally formatted mailing labels without duplicate field errors.
- 1. Start the Mail Merge: Open WPS Writer, navigate to the 'References' tab, and click on 'Mail Merge' to activate the tools.
- 2. Import your address list: Click 'Open Data Source' and browse your computer to select your cleanly formatted Excel address list.
- 3. Insert merge fields: Place your cursor in the document and click 'Insert Merge Field' to place the First Name, Last Name, Address, and City exactly where they belong.
- 4. Merge to new document: Once your layout is perfect, click 'Merge to Different New Document' to generate your final, error-free printable labels.
Frequently Asked Questions
Why is the same name repeating on every single label?
This happens when the '<<Next Record>>' rule is missing from your label template. Ensure you click the 'Update Labels' button on the Mailings tab so Word can automatically insert the '<<Next Record>>' command before the fields in all subsequent labels.
How do I edit my Excel data source directly from Word?
Go to the Mailings tab and click 'Edit Recipient List'. In the dialog box that appears, select your data source file under the 'Data Source' section at the bottom, and click 'Edit'. However, for large structural changes like splitting columns, it is safer to close Word and edit the file directly in Excel.
How can I prevent blank lines when an address field is empty?
By default, modern versions of Word suppress blank lines for empty merge fields. If a blank line still appears, check if there are extra spaces or punctuation marks next to the merge field, as these characters will force the line to print even if the field itself is empty.
