Fix Mail Merge Hyperlinks Keeping Original URLs in Word
Question details
The user is experiencing an issue where hyperlinks generated through a Word mail merge using Excel data display the correct text but direct to the original template's URL.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Creating a mail merge document using an Excel data source to generate dynamic hyperlinks.
- Observed behavior
- The merged document displays the new URL text from the Excel data, but clicking the link redirects to the original hyperlink configured in the Word template.
Ensure your Excel data source contains the full, correctly formatted URLs (including https://) and verify your current Office version by navigating to File > Account > Product Information.
Construct a Field-Based Hyperlink
Instead of typing a standard hyperlink, use Word's field codes to dynamically pull the URL from your Excel data source.
When a standard hyperlink is embedded in a mail merge document, Word only replaces the display text but retains the original URL in the link properties. Constructing a nested field code forces Word to update both the display text and the actual destination URL based on your data source.
Open your Word mail merge template and press Alt + F9 (or Fn + Alt + F9 on some laptops) to reveal the underlying field codes.
Press Ctrl + F9 to insert a new set of field braces { }, and type HYPERLINK inside them.
Inside the HYPERLINK field, add a space, then press Ctrl + F9 again to insert another set of braces. Type MERGEFIELD followed by your URL column name. The final code should look like { HYPERLINK "{ MERGEFIELD YourURLColumnName }" }.
Press Alt + F9 to hide the field codes. Select the new hyperlink text and press F9 to update the field before completing your mail merge.
Ignore Deprecation Warnings for Word Mail Merge
Clarification that Word mail merge is fully supported and not deprecated, unlike certain Dynamics 365 templates.
Create Dynamic Mail Merge Documents with WPS Office
WPS Writer offers a highly intuitive Mail Merge feature that seamlessly integrates with spreadsheets. You can easily insert dynamic hyperlink fields and generate personalized documents without complex field code troubleshooting.
- 1. Open Mail Merge in WPS Writer: Launch WPS Writer, navigate to the 'References' tab on the top ribbon, and click on 'Mail Merge'.
- 2. Connect the data source: Click 'Open Data Source', select your spreadsheet containing the hyperlink URLs, and click 'Open'.
- 3. Insert merge fields: Place your cursor where you want the link, click 'Insert Merge Field', and select the column containing your URLs.
- 4. Complete the merge: Click 'Merge to New Document' to generate your final personalized files with properly functioning links.
Frequently Asked Questions
Why does the mail merge hyperlink text update, but the link destination stays the same?
This happens when a standard hyperlink is inserted directly into the Word template. Word updates the display text with the merge field data, but retains the hardcoded URL in the link properties. Using dynamic field codes (HYPERLINK and MERGEFIELD) forces Word to update the destination URL.
Is the Mail Merge feature being removed from Microsoft Word?
No, the Mail Merge feature in Microsoft Word has been a core tool for decades and remains fully supported. Deprecation notices regarding mail merge templates apply only to Microsoft Dynamics 365, not the desktop Word application.
How do I make the dynamic hyperlink display custom text instead of the long URL?
You can achieve this by modifying the field code structure. Instead of just displaying the URL, you can structure your document to embed the hyperlink behind a custom text phrase using a slightly more complex combination of fields, or by ensuring the merge field strictly dictates the URL destination while you manually edit the display text above the hidden field codes.
Do I need to include the 'http://' prefix in my Excel data?
Yes, it is highly recommended to include the full URL structure (http:// or https://) in your Excel data source to ensure Word properly recognizes and formats the merged data as an active, clickable web link.
