How to Fix Hyperlinks Merging in a Word Email Mail Merge
Question details
The user needs a solution to stop multiple hyperlinks from combining into one large link when running an email mail merge in Word.

- Product
- Word Document Editor
- Device & OS
- not provided
- Scenario
- Sending personalized emails containing multiple independent hyperlinks using the mail merge feature.
- Observed behavior
- During the mail merge, the multiple hyperlinks incorrectly merge together, causing the first link to cover the entire email message body.
Ensure your data source containing the correct individual URLs is properly prepared and linked to your main mail merge document before adjusting the field codes.
Use Hyperlink Field Codes to Keep Links Independent
Toggle the field codes of your hyperlinks to manually insert the specific merge fields into the URL paths, ensuring each link functions separately in the final merged emails.
By default, the mail merge process might treat subsequent text as part of the first hyperlink if the field boundaries are not explicitly defined. Modifying the underlying field codes forces the document to treat each link as a separate entity.
Highlight your display text, right-click, and select 'Hyperlink' (or press Ctrl+K) to insert a standard hyperlink into your document as you normally would.
Select the inserted hyperlink in your document and press Shift+F9 to reveal its underlying field code structure.
Delete the static URL path located after the word 'HYPERLINK' within the brackets, and use the 'Insert Merge Field' button on the Mailings tab to place your specific URL merge field there instead.
Repeat the previous steps for every individual hyperlink you need to include in your email message to ensure they all have distinct merge fields assigned.
After completing the mail merge setup, press Ctrl+A to select the entire document, then press F9 to update all fields. This resets the display and ensures each hyperlink remains independently clickable.

Easily Manage Mail Merges and Hyperlinks with WPS Office
WPS Writer provides robust mail merge capabilities, allowing you to seamlessly integrate personalized hyperlinks into your mass emails or letters with an intuitive interface.
- 1. Open the Mailings Tab: Launch WPS Writer, open your email template document, and navigate to the Mailings tab located on the top ribbon.
- 2. Connect Data Source: Click 'Open Data Source' to browse and connect your spreadsheet or database containing the unique URLs for your recipients.
- 3. Insert Merge Fields: Click 'Insert Merge Field' to place your personalized data and dynamic link paths directly into the document's hyperlink codes.
- 4. Execute the Email Merge: Click 'Merge to E-mail', fill in the appropriate subject line, and send your personalized messages out with perfectly functioning independent links.

Frequently Asked Questions
Why do my mail merge hyperlinks point to the same web address?
This usually happens if the display text is populated by the merge, but the underlying hyperlink path remains static. You must edit the hyperlink field code (using Shift+F9) to replace the static URL with your dynamic merge field so each link updates based on the recipient data.
How do I hide field codes after editing them in my document?
Once you have finished adding your merge fields into the hyperlink code, you can press Shift+F9 again while selecting the specific field, or press Alt+F9 to toggle all field codes in the entire document back to their normal, clickable display text.
Can I format the text of a hyperlink inserted via mail merge?
Yes. You can select the merge field placeholder or the resulting hyperlink text and apply standard text formatting such as bolding, colors, or fonts directly from the Home tab. The formatting will persist after the merge is completed.




