Document Editing Problems

How to Fix Word Mail Merge Hyperlinks Missing from Emails

Khadija KhanKhadija Khan Oct 12, 2026 880 views

Question details

Users experience disappearing or unclickable hyperlinks in some emails when performing a bulk mail merge in Microsoft Word.

How to Fix Missing Hyperlinks in Word Mail Merge Emails
Product
Microsoft Word
Device & OS
not provided
Scenario
Sending a bulk email campaign or personalized messages using the Mail Merge feature.
Observed behavior
Hyperlinks are stripped out, converted to plain static text, or become unclickable in the final sent emails.
Before you start

Before proceeding, ensure your default email client (such as Outlook) is running and configured to handle HTML messages, and save a backup copy of your mailing list and main document.

Solution 1Recommended

Change Mail Merge Email Format to HTML

Switching your output format from Plain Text to HTML is the most effective way to ensure hyperlinks remain active and clickable.

Plain-text messages are designed to strip all rich formatting, including clickable URLs and custom fonts. Sending your mail merge as an HTML message preserves the hyperlink structure.

1
Navigate to Finish & Merge

In your Word document, go to the 'Mailings' tab on the top ribbon and click on 'Finish & Merge' in the final section.

2
Select Send Email Messages

From the dropdown menu, select 'Send Email Messages...' to open the Merge to E-mail dialog box.

3
Adjust the Mail Format

Locate the 'Mail format' dropdown option. Change it from 'Plain Text' to 'HTML' or 'Attachment'.

4
Execute the Merge

Click 'OK' to send the emails. The hyperlinks will now be preserved as clickable elements in the recipients' inboxes.

Change Mail Merge Email Format to HTML
Test Before Sending: Always run a small test merge to your own email address to verify the HTML formatting and link functionality before sending it to your entire recipient list.

Perform Mail Merge with Clickable Links in WPS Office

WPS Writer offers a highly compatible and intuitive Mail Merge feature. You can effortlessly send personalized emails with intact HTML formatting and active hyperlinks without dealing with complex field code errors.

  1. 1. Open Your Document: Launch WPS Writer and open your main email template document.
  2. 2. Import Data Source: Go to the 'Mailings' tab, click 'Open Data Source', and select your Excel or CSV contact list.
  3. 3. Insert Merge Fields: Click 'Insert Merge Field' to add personalized data and hyperlink URLs where needed.
  4. 4. Merge to Email: Click 'Merge to Email', ensure the format is set to HTML, and send your fully functional emails.
Fully compatible with Microsoft Word documents (.docx) and Excel data sources.Natively supports HTML email formatting to preserve hyperlinks and rich text.Lightweight architecture ensures faster processing for large recipient lists.Free to download with a familiar, user-friendly ribbon interface.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my hyperlinks turn into plain text during a mail merge?

This usually happens because the 'Mail format' in the Merge to E-mail dialog is set to 'Plain Text'. Plain text strips all rich formatting, turning clickable links into standard text. Changing this setting to 'HTML' resolves the issue.

Can I include unique, personalized hyperlinks for each recipient in a mail merge?

Yes. You can achieve this by using the HYPERLINK field code combined with a MERGEFIELD. Your data source (like Excel) must contain a column with the unique URLs. You then nest the MERGEFIELD for that column inside the HYPERLINK field code.

How can I test my mail merge before sending it to a large list?

You can filter your recipient list by selecting 'Edit Recipient List' and unchecking all contacts except your own email address. Alternatively, create a small sample data source to execute a test merge and verify formatting.

Does saving the document as PDF preserve the mail merge hyperlinks?

Yes, if you merge the document to a PDF file instead of sending it directly via email, the hyperlinks will generally remain clickable, provided they are formatted correctly in the original document.