Others

How to Create HTML Outlook Emails from a Word Mail Merge Macro

Huma Ashraf Ch Sep 30, 2026 869 views

Question details

The user needs to generate HTML-formatted emails in Outlook using a Word mail merge macro, bypassing the default plain-text output, and troubleshoot DDE automation freezes.

How to Create HTML Outlook Emails from a Word Mail Merge Macro

Product: Microsoft Word
Device & OS: Windows 10 32-bit
Scenario: Automating email creation with a Word macro via DDE or add-ins to send rich-text/HTML emails instead of standard plain text.
Observed behavior: Saving the mail merge document as text produces plain-text emails. Additionally, calling Word from a legacy 32-bit application using DDE causes the system to freeze.

Before you start

Ensure you are using the classic version of Microsoft Outlook, as the 'New Outlook' does not support the COM automation required for third-party mail merge add-ins.

Solution 1Recommended

Use a Compatible Merge Tools Add-in

Bypass Word's default plain-text limitation by installing a dedicated Merge Tools add-in that supports HTML formatting and advanced email routing.

Saving a document using Word's default text format macro inherently strips formatting, resulting in plain-text Outlook emails.

By utilizing a third-party Merge Tools add-in, you can generate merged Outlook messages in HTML format. These tools also add support for attachments, CC, BCC, and data-driven subjects.

Set the document type

Open your mail merge document in Microsoft Word and ensure the merge type is strictly set to 'Letters'.

Verify data fields

Check your data source (e.g., Excel) to ensure all field names meet the specific naming conventions required by your installed Merge Tools add-in.

Run the HTML merge

Execute the merge using the add-in's dedicated ribbon button to generate HTML emails directly into your classic Outlook outbox.

Outlook Version Requirement: This add-in method is incompatible with the 'New Outlook'. You must switch back to the classic Outlook interface for the automation to function properly.

Solution 2

Troubleshoot Legacy DDE Application Freezes

Address freezing issues when a 32-bit legacy application uses DDE to trigger a Word mail merge macro.

Free Microsoft Office alternative

Switch to WPS Office for Reliable Document Automation

If Microsoft Word's mail merge macros and DDE legacy integrations are causing freezing or formatting limitations, consider switching to WPS Office. It offers a lightweight, highly compatible alternative for everyday document generation and bulk mailing tasks without the bloat.

1. Open WPS Writer: Launch WPS Writer and navigate to the 'References' or 'Mailings' tab to access the Mail Merge tools.
2. Import data source: Click 'Open Data Source' and select your spreadsheet containing the email contacts and information.
3. Merge to email: Insert your desired merge fields, then click 'Merge to Email' to send your formatted messages.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formatsBuilt-in, intuitive Mail Merge feature for letters and emailsFree, lightweight, and fast to launch on WindowsFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Word mail merge macro send plain-text emails?

When a macro saves a document using Word's default text format during the merge process, it strips out rich text and HTML data, resulting in a plain-text email in Outlook.

Can I use mail merge add-ins with the new Outlook?

No. Most advanced mail merge tools and add-ins rely on COM automation, which is not supported in the 'New Outlook'. You must revert to classic Outlook to use these features.

How do I fix Word freezing when called by a legacy DDE application?

Modern versions of Microsoft 365 often struggle to handle DDE (Dynamic Data Exchange) calls from 32-bit legacy apps, leading to system freezes. It is highly recommended to update the integration to use COM automation instead.

Office Quick Solutions