Formatting Issues

How to Fix Word and Excel Mail Merge Formatting Issues in Gmail

Guest Writer Sep 28, 2026 869 views

Question details

The user needs to prevent Word and Excel mail merge documents from appearing distorted when sent as HTML emails to Gmail recipients.

How to Fix Word and Excel Mail Merge Formatting Problems in Gmail

Product: Word, Excel, Outlook, Gmail
Device & OS: not provided
Scenario: Sending a mail merge from Word and Excel through Outlook to Gmail users.
Observed behavior: The mail merge formatting appears correctly in Word and Outlook but becomes distorted when viewed in Gmail due to differences in HTML rendering.

Before you start

Ensure you are using the classic version of Outlook, as some third-party mail merge add-ins are not yet compatible with the 'new Outlook' application.

Solution 1Recommended

Send Mail Merge as PDF Attachments

Bypass HTML rendering issues in Gmail by attaching the mail merge documents as PDF files.

Email clients like Gmail interpret HTML tables differently than desktop applications, causing consistent formatting to be difficult.

By converting each record into a PDF attachment, you preserve the exact layout and formatting designed in your original Word document.

Install a Mail Merge Add-in

Download and install a compatible mail merge tool, such as the Merge Tools Add-in, that supports merging to email messages with PDF attachments.

Prepare the Document

Set up your main document as a 'Letters-type' mail merge document in Microsoft Word.

Verify Field Names

Check your Excel data source to ensure all field names are valid and properly formatted without unsupported characters.

Execute the Merge

Run the add-in to generate individual PDF files for each recipient and attach them automatically to the outgoing messages in Outlook.

Outlook Compatibility: The Merge Tools Add-in does not currently support the 'new Outlook' application. You may need to revert to the classic Outlook application to use this method.

Free Microsoft Office alternative

Experience Seamless Document Creation with WPS Office

If you're tired of formatting issues and add-in compatibility problems in Microsoft Office, try WPS Office. It provides a lightweight, free, and highly compatible alternative with familiar features to handle your daily documents, spreadsheets, and PDF exports.

1. Download WPS Office: Visit the official WPS website to download the free installer for your operating system.
2. Install the Software: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
3. Open Your Files: Launch WPS Writer or WPS Spreadsheet and seamlessly open your existing Microsoft Office files without losing formatting.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Built-in export to PDF features to preserve exact document formatting.Familiar user interface with no steep learning curve.Lightweight application that runs smoothly on almost any device.

Frequently Asked Questions

Why does my mail merge look different in Gmail compared to Outlook?

Different email clients use different rendering engines for HTML. Gmail may strip or alter certain CSS styles and HTML table properties that Microsoft Word and Outlook generate, leading to distorted layouts.

Do I need a third-party add-in to send mail merges as PDF attachments?

Yes, by default, the standard Word mail merge to email sends the content as the email body. To send individual PDF attachments for each record, you typically need a third-party add-in or a custom VBA macro.

What is a 'Letters-type' mail merge document?

A Letters-type mail merge document is the standard document type in Word designed for creating individual letters. Add-ins often require this specific format to properly generate individual attachments, as opposed to using the 'Directory' or 'Email Messages' types.

Why isn't my mail merge add-in working with the new Outlook?

The 'new Outlook' application is based on a different web-based architecture and currently lacks support for many COM add-ins and legacy automation processes that work smoothly with the classic desktop version of Outlook.

Document & File Issues