How to Fix Word Mail Merge Hyperlinks Missing from Emails
Question details
Users experience disappearing or unclickable hyperlinks in some emails when performing a bulk mail merge in Microsoft Word.

- 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 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.
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.
In your Word document, go to the 'Mailings' tab on the top ribbon and click on 'Finish & Merge' in the final section.
From the dropdown menu, select 'Send Email Messages...' to open the Merge to E-mail dialog box.
Locate the 'Mail format' dropdown option. Change it from 'Plain Text' to 'HTML' or 'Attachment'.
Click 'OK' to send the emails. The hyperlinks will now be preserved as clickable elements in the recipients' inboxes.

Adjust Hyperlink Field Codes with Bookmarks
Modify the underlying field codes if Word is incorrectly replacing the merge field with a static hyperlink during the merge process.
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. Open Your Document: Launch WPS Writer and open your main email template document.
- 2. Import Data Source: Go to the 'Mailings' tab, click 'Open Data Source', and select your Excel or CSV contact list.
- 3. Insert Merge Fields: Click 'Insert Merge Field' to add personalized data and hyperlink URLs where needed.
- 4. Merge to Email: Click 'Merge to Email', ensure the format is set to HTML, and send your fully functional emails.

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.




