How to Preserve Formatting in Word Mail Merge

To preserve formatting in Word mail merge, use the correct account, product, permissions, and destination. This guide explains the supported workflow and the checks that confirm the result.

Protect the Document and Check Its Editing State

Confirm the owning account, required permissions, affected files or services, and the exact outcome you need. Keep a backup when the task changes local content or removes access.

Quick Word Check

First, open the Word mail-merge main document and press Alt+F9 to display field codes. Next, add the required numeric or date-format switch inside the affected merge field, such as a numeric picture switch, without changing the field name, and verify the final state before changing any backup or secondary account.

How to Preserve Formatting in Word Mail Merge

1. Open the Word mail-merge main document and press Alt+F9 to display field codes
2. Add the required numeric or date-format switch inside the affected merge field, such as a numeric picture switch, without changing the field name
3. Press Alt+F9 again, select Mailings > Preview Results, and inspect several records with different source values
4. If the source is Excel, store dates and numbers as real values rather than preformatted text, then reconnect the recipient list
5. Complete a merge to a new document first and verify formatting before sending email or printing the full merge

After the final step, reopen the affected app, portal, file, or account page and confirm the exact status or behavior described in the title.

WPS Office: A Leading Free Alternative to Microsoft Office

If preserving formatting in Word mail merge depends on a Microsoft-only setting, add-in, macro, account, or cloud service, WPS Office cannot change that proprietary state. Complete the Microsoft-side step with the official control described above.

While you work on preserving formatting in Word mail merge, WPS Office provides a free Microsoft Office-compatible workspace through WPS Writer. It opens and saves common DOCX, XLSX, PPTX, and PDF files in a familiar interface, so related local work can continue without waiting for the Microsoft-side issue to be fixed.

For work related to preserving formatting in Word mail merge, WPS AI in Writer can help draft, rewrite, polish, translate, and summarize text while you keep the document in a familiar Word-compatible workspace.

Test advanced macros, add-ins, external connections, sensitivity controls, and Microsoft-only cloud integrations on a copy before moving a critical workflow. WPS AI availability and usage limits can vary by plan, platform, region, and app version.

Practical Checks That Prevent a Repeat

• Record which account, app, and file owns the workflow
• Keep a verified backup before removing access, changing ownership, or replacing a local file
• Apply high-impact changes to one test item or user before expanding the scope
• Save confirmation numbers, dates, and screenshots of the final settings when they affect billing, security, or permissions

Frequently Asked Questions

Which field should Word use as the email recipient?

In Finish & Merge > Send E-mail Messages, choose the column containing verified email addresses. Preview several records before sending.

Why does mail-merge formatting change between records?

Formatting can come from the Word field code, the source value, or the paragraph style. Toggle field codes and apply formatting to the complete merge field.

Can I test a mail merge without emailing everyone?

Yes. Filter the recipient list to one or two addresses, complete the merge, and inspect the received message before removing the filter.

How can I confirm that preserving formatting in Word mail merge was successful?

Complete a merge to a new document first and verify formatting before sending email or printing the full merge. Repeat the original action and confirm that the result remains after reopening the app, file, or portal.