Document Editing Problems

Fix Random Letters or Truncated Text in Word Mail Merge

Natalie TaylorNatalie Taylor Nov 20, 2026 868 views

Question details

The user needs Word mail merge to insert complete, correct text from an Excel data source.

Fix Random Letters or Truncated Text in Word Mail Merge
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
Merging Excel data into a Word mail-merge document.
Observed behavior
Some merged fields contain unexpected letters or display truncated text.
Before you start

Identify an affected recipient and field, then check the original cell and column heading in Excel. In Word, use Mailings > Preview Results to compare the merged result with the source.

Solution 1Recommended

Check and reinsert the affected merge field

Use this approach when one field inserts unexpected characters or does not match its Excel column.

1
Check the Excel heading

Open the source workbook in Excel and find the affected column heading and cell. Confirm that the heading is unique and that the cell contains the complete expected text.

2
Try a different heading

If the heading appears to be causing the issue, append 1 to its name, save the workbook, and close it. This resolved unexpected letters in the reported case, but may not fix every merge.

3
Reconnect the source

In Word, select Mailings > Select Recipients > Use an Existing List, choose the saved workbook, and select the relevant worksheet.

4
Reinsert and preview the field

Delete the affected merge field, then select Mailings > Insert Merge Field and choose the matching column. Select Preview Results and navigate to the affected recipient to check the text.

Check and reinsert the affected merge field
Free Microsoft Office alternative

Edit Word and Excel Files with WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, though it does not repair Word mail-merge issues.

Open and edit Microsoft Word DOCX and Excel XLSX filesReview document text and spreadsheet source data in one office suiteUse a familiar interface that makes switching easierWork with a free, lightweight office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word mail merge insert unexpected letters?

The wrong or incorrectly edited merge field may be responsible. Check the Excel column heading, then delete and reinsert the matching field using Mailings > Insert Merge Field.

Will adding 1 to an Excel column heading fix the merge?

It resolved unexpected letters in the reported case, but it is not a guaranteed fix. After renaming the heading, save the workbook, reconnect it through Mailings > Select Recipients, and reinsert the field.

How can I check whether text is being cut off in Excel or Word?

Open the affected cell in Excel and check its complete value. Then use Word's Mailings > Preview Results to compare the merged output with that value.

What should I do if a new merge document still truncates text?

Test a new Excel workbook with sample data and compare its field names, data types, and formatting with the original. If the issue persists, provide Microsoft Support with the Office version, when the issue started, and any recent changes.