Preserve Excel Data Formatting in a Word Mail Merge
Question details
The user needs to merge Excel data into Word while retaining the required text formatting and checking that long fields are complete.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel worksheet is used as the data source for a Word mail merge, with formatting and text length varying across fields or records.
- Observed behavior
- Excel cell formatting is not reliably preserved in the merged document, and some long text fields may lose trailing text.
Open the Word merge document and its Excel data source, and identify fields that need consistent formatting or contain long, multiline text. Include records with different formatting and long values in your test.
Apply Consistent Formatting to the Word Merge Field
Use this method when every record should have the same character formatting for a particular field.
The CHARFORMAT switch applies the character formatting of the first character of the field code to the field result. It does not import different colors or formatting from individual Excel cells.
In the Word merge document, select the merge field and toggle its field code. On Windows, press Alt+F9 to show field codes in the document.
Edit the code to include the CHARFORMAT switch, for example: { MERGEFIELD myfield \* Charformat }. Replace myfield with your actual field name and remove a conflicting \* Mergeformat switch if present.
Select the first character of MERGEFIELD and use Home > Font to apply the desired font, color, or underline.
Select the field and press F9 to update it, then use Mailings > Preview Results to check several records. Finish the merge to a document and review the results.

Use Automation for Record-Specific Excel Formatting
Use VBA or another automation method when formatting differs by record or within an Excel cell.
Review and Correct Long Merged Fields
Use this check when merged output appears to omit trailing text or line breaks.
Work With Merge Documents and Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open compatible Office files to make the transition easier; WPS does not fix formatting behavior in Microsoft Word mail merge.

Frequently Asked Questions
Why doesn't Word copy the colors and underlining from Excel?
A standard Word mail merge generally uses the Excel cell value rather than reproducing its cell or character formatting. Apply consistent formatting to the Word field with \* Charformat, or use automation when formatting must vary by record.
How do I see the MERGEFIELD code in Word?
On Windows, press Alt+F9 in the merge document to toggle field codes. You can then edit the field code and press F9 to update the selected field.
Can CHARFORMAT preserve different formatting within one Excel cell?
No. CHARFORMAT applies the formatting of the first character of the Word field code to the field result; it does not reproduce mixed formatting from the source cell. Use VBA or another automation method to read and apply those formatting runs.
What should I do if a long Excel field is cut off in the merge?
Compare the full Excel cell value with the merged result, check the data source through Mailings > Select Recipients, and test long and multiline records. If text is still missing, correct the finished document manually or use automation.




