Document Editing Problems

Fix Mail Merge Hyperlinks Sending the Same URL in Every Email

WPS Editor Oct 1, 2026 868 views

Question details

The user needs to configure dynamic hyperlink merge fields so that each recipient receives their unique URL instead of the same static link during a mail merge.

How to Fix Mail Merge Hyperlinks Sending the Same Link to Every Recipient

Product: Word Processor
Device & OS: not provided
Scenario: Sending bulk customized emails using the Mail Merge feature with personalized hyperlinks.
Observed behavior: Personalized hyperlinks look correct in the mail merge preview but end up sending the same static URL to every recipient.

Before you start

Ensure your data source (such as an Excel spreadsheet) contains a dedicated column with the complete, unique URLs for each recipient before initiating the mail merge.

Solution 1Recommended

Configure Hyperlink as a Dynamic Merge Field

Convert your static hyperlink into a dynamic field code so that the word processor pulls the unique URL for each recipient directly from your data source.

When you simply insert a hyperlink and use a merge field as the display text, the underlying URL remains static. To force the program to update the destination URL for each email, you must nest a MERGEFIELD inside a HYPERLINK field.

Reveal Field Codes

Open your mail merge document and press 'Alt + F9' on your keyboard to reveal all field codes in the document.

Insert the Hyperlink Field

Position your cursor where you want the link to appear. Press 'Ctrl + F9' to insert a pair of blank field brackets { }. Type the word HYPERLINK inside them, followed by a space.

Nest the Merge Field

Inside the HYPERLINK field, add quotation marks. Click between the quotation marks, press 'Ctrl + F9' again to insert another set of brackets, and type MERGEFIELD followed by the exact name of your URL column in your spreadsheet (e.g., { HYPERLINK "{ MERGEFIELD URL_Column }" }).

Hide Codes and Update

Press 'Alt + F9' to hide the field codes. Select the text, press 'F9' to update the field, and then proceed to complete your mail merge.

Configure Hyperlink as a Dynamic Merge Field

Important Note on Previews: Do not trust the document preview for dynamic hyperlinks, as it often only displays the first record's link. Always run a test merge to a small batch of your own email addresses to verify the links work properly before sending to your entire list.

Efficient Document Processing

Create Dynamic Mail Merges Easily with WPS Office

WPS Writer offers a seamless and highly compatible Mail Merge feature that correctly handles dynamic hyperlink fields, ensuring your personalized bulk emails reach recipients flawlessly.

1. Open WPS Writer: Launch WPS Writer, open your main email template document, and navigate to the 'Mailings' tab on the top ribbon.
2. Connect Data Source: Click 'Open Data Source' and select the spreadsheet containing your recipient emails and their unique destination URLs.
3. Insert Field Codes: Use the standard keyboard shortcuts (Ctrl + F9) to create nested dynamic fields for your URLs, ensuring each recipient gets a custom link.
4. Preview Results: Click 'View Merged Data' to double-check that the display text for your recipient names and other standard fields populate correctly.
5. Merge to Email: Click 'Merge to E-mail', specify the email column from your data source, and send your personalized campaign.

Fully compatible with Microsoft Word document formats (.docx) and Excel data sources.Intuitive Mail Merge wizard to easily insert dynamic data and handle complex field codes.Free and lightweight alternative for processing bulk personalized emails quickly.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my mail merge preview show the correct links, but the sent emails do not?

The preview function often caches the first record's hyperlink text or only visually updates the display text without updating the underlying hyperlink address. Using nested field codes forces the system to generate a new URL for every single email during the final merge process.

Can I pull hyperlinks directly from Excel without using field codes?

No, the mail merge function extracts raw text data from your spreadsheet. If you just insert a standard hyperlink into your document and link the display text to an Excel cell, the underlying URL destination remains static. You must use the dynamic field code method.

How do I change the display text of my dynamic mail merge link so it doesn't just show the raw URL?

To show a friendly name (like 'Click Here') instead of the raw URL, you can structure your field code to include a display text switch, or highlight the completed field code bracket structure, right-click, select 'Edit Hyperlink', and set the 'Text to display' field.

What should the column header in my data source be named?

You can name the column header anything you like, such as 'Website', 'Link', or 'PersonalURL'. Just ensure that when you build the MERGEFIELD code in your document, the name exactly matches the column header in your spreadsheet.

Document & File Issues