Formatting Issues

Preserve Excel Data Formatting in a Word Mail Merge

Emma BrownEmma Brown Nov 22, 2026 868 views

Question details

The user needs to merge Excel data into Word while retaining the required text formatting and checking that long fields are complete.

Preserve Excel Data Formatting in a Word Mail Merge
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.
Before you start

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.

Solution 1Recommended

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.

1
Show the field code

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.

2
Add the switch

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.

3
Format the field code

Select the first character of MERGEFIELD and use Home > Font to apply the desired font, color, or underline.

4
Update and test the merge

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.

Apply Consistent Formatting to the Word Merge Field
Check complete text: Compare long and multiline merged fields with the source cells in Excel. CHARFORMAT controls character formatting; it does not fix text truncation.
Free Microsoft Office alternative

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.

Review and edit document text and formatting in WPS WriterOpen and work with Microsoft Word DOCX and Excel XLSX filesUse a familiar interface for documents and spreadsheetsGet a free, lightweight Office alternative
microsoft office alternative - wps office

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.