Fix Random Letters or Truncated Text in Word Mail Merge
Question details
The user needs Word mail merge to insert complete, correct text from an Excel data source.

- 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.
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.
Check and reinsert the affected merge field
Use this approach when one field inserts unexpected characters or does not match its Excel column.
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.
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.
In Word, select Mailings > Select Recipients > Use an Existing List, choose the saved workbook, and select the relevant worksheet.
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.

Test a new Excel source and Word merge document
Use a small test to determine whether the original workbook or merge document is contributing to the problem.
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.

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.




