Formatting Issues

How to Fix Unexpected Question Marks in Word Mail Merge Address Fields

Adam Davis Sep 27, 2026 868 views

Question details

Users are encountering unexpected question marks at the end of address lines when running a mail merge.

Fix Question Marks in Word Mail Merge Address Fields

Product: Word
Device & OS: not provided
Scenario: Performing a document or label mail merge in Word using an Excel spreadsheet as the address list data source.
Observed behavior: An unwanted question mark is automatically added to the end of the address block when the default AddressBlock field is used.

Before you start

Verify that your Excel source file does not contain hidden characters or trailing spaces in the address cells before proceeding with the mail merge troubleshooting.

Solution 1Recommended

Replace the AddressBlock with Individual Merge Fields

Manually inserting individual merge fields prevents formatting glitches and unexpected characters caused by the default AddressBlock mapping.

The built-in AddressBlock field attempts to auto-format address data based on region and pre-defined rules, which can misinterpret data from Excel and insert unrecognized characters (displayed as question marks). Building the address block manually gives you complete control over the layout.

Delete the existing AddressBlock

Open your Word document and delete the existing <<AddressBlock>> field from your page layout.

Navigate to the Mailings tab

Click on the 'Mailings' tab in the top ribbon and ensure your Excel recipient list is still selected.

Insert individual fields manually

Click 'Insert Merge Field' and select each field manually (e.g., Company Name, Street Address, City, State, ZIP Code) into the document.

Format the address layout

Add spaces, commas, and line breaks manually between your newly inserted fields (e.g., <<City>>, <<State>> <<ZIP Code>>) to create a standard address format.

Preview the results

Click 'Preview Results' on the Mailings tab to verify that the addresses now display correctly without any trailing question marks.

Replace the AddressBlock with Individual Merge Fields

Formatting Complete: By arranging the fields manually, you bypass mapping errors and ensure each address prints exactly as intended.

Seamless Mail Merge with WPS Office

Perform Flawless Mail Merges Using WPS Writer

WPS Office provides a highly compatible and user-friendly Mail Merge feature, allowing you to seamlessly link spreadsheets to documents without formatting glitches or unwanted characters.

1. Open your document: Launch WPS Writer and open your letter or label document template.
2. Access Mail Merge: Go to the 'References' tab and select 'Mail Merge' to open the dedicated mailings toolbar.
3. Import data source: Click 'Open Data Source' and select your spreadsheet containing the prepared address list.
4. Insert merge fields: Use the 'Insert Merge Field' button to precisely place individual fields like Name, Address, and City directly into your document.
5. Preview and finish: Click 'View Merged Data' to preview your clean, accurately formatted addresses before completing the merge.

Fully compatible with Microsoft Word and Excel file formats (.docx, .xlsx).Intuitive Mail Merge wizard for precise insertion of individual fields.Complete layout control to avoid hidden characters or unwanted question marks.Free and lightweight office suite for Windows, Mac, and Linux.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the AddressBlock field add a question mark?

The AddressBlock field sometimes struggles to map international or custom address layouts from Excel correctly, resulting in unrecognized line breaks or non-printable characters that render as question marks in Word.

Can I fix this by cleaning my Excel data source?

Yes, sometimes the issue stems from the spreadsheet. You can try using the CLEAN() or TRIM() functions in Excel to remove non-printable characters or trailing spaces from your address columns before running the mail merge.

Does replacing the AddressBlock with individual fields affect my ability to print labels?

No. You can insert individual merge fields into the first label of your document and then click 'Update Labels' to populate the rest of the sheet, just as you would with an AddressBlock.

How do I format the ZIP code so it doesn't drop the leading zero during a mail merge?

In Word, you can add a picture switch to the merge field by pressing Alt+F9 to reveal field codes, finding the ZIP code field, and adding '\# "00000"' to ensure it always displays as five digits.

Document & File Issues