Document Editing Problems

How to Preserve Hyperlinks Inside IF Fields in a Word Mail Merge

Algirdas Jasaitis Sep 27, 2026 869 views

Question details

The user needs a way to retain clickable hyperlink formatting when a URL is generated conditionally via an IF field during a mail merge.

How to Preserve Hyperlinks Inside IF Fields in a Word Mail Merge

Product: Word Processor
Device & OS: not provided
Scenario: Executing a document mail merge where specific hyperlinks are inserted based on conditional logic using IF fields.
Observed behavior: Hyperlinks work correctly outside the conditional field, but revert to unclickable plain text when output as the result of a nested IF field after the merge.

Before you start

Ensure your mail merge data source contains full, valid URL structures (e.g., starting with http:// or https://) and create a backup of your main mail merge document before altering field codes.

Solution 1Recommended

Output URL as Plain Text and Apply AutoFormat Post-Merge

Since field results strip hyperlink metadata, the most reliable method is to output the URL as plain text and use the AutoFormat feature to activate the links in the final merged document.

This solution works by bypassing the limitation of nested field codes. By configuring Word or WPS Writer to automatically format internet paths, you can quickly convert the plain text URLs into active hyperlinks after generating the merged file.

Edit the IF Field Code

Press Alt+F9 to reveal field codes in your document. Modify your IF field so that the true/false results output the raw URL text without any nested HYPERLINK field wrappers (e.g., { IF { MERGEFIELD Status } = "Active" "https://example.com" "" }).

Execute the Mail Merge

Navigate to the Mailings tab and click 'Finish & Merge' (or 'Merge to New Document'). This generates a new document where your conditions are evaluated, and the plain text URLs are printed.

Enable Internet Paths AutoFormat

In the newly merged document, go to File > Options > Proofing > AutoCorrect Options. Under the 'AutoFormat' and 'AutoFormat As You Type' tabs, ensure that 'Internet and network paths with hyperlinks' is checked.

Run AutoFormat or Macro

Use the built-in AutoFormat command to instantly convert all URLs to clickable links. Alternatively, run a brief VBA macro that temporarily turns on AutoFormat, applies it to the document, and restores your previous settings.

Output URL as Plain Text and Apply AutoFormat Post-Merge

Macro Automation: If you perform this merge frequently, recording a macro of the AutoFormat process will save you from manually clicking through the options each time.

Solution 2

Wrap the IF Field Inside the HYPERLINK Field

Instead of putting the HYPERLINK inside the IF field, reverse the nesting order to maintain the clickable link structure.

Advanced Document Editing

Execute Conditional Mail Merges Efficiently in WPS Writer

WPS Office provides a robust, user-friendly Mail Merge toolkit that handles complex field codes, data sources, and formatting with ease. It offers excellent compatibility with standard Word documents, ensuring your automated workflows run smoothly.

1. Open Document and Access Mailings: Launch WPS Writer, open your main document, and navigate to the 'Mailings' tab on the top ribbon.
2. Connect Data Source: Click 'Open Data Source' to link your spreadsheet or database containing the URL fields and condition rules.
3. Insert Field Codes: Use the 'Insert Merge Field' button and standard keyboard shortcuts (Ctrl+F9) to build your conditional IF fields directly in the text editor.
4. Finish and Format: Click 'Merge to New Document' to generate your final file, where you can quickly apply AutoFormat to activate all plain text URLs.

Highly compatible with Microsoft Word field codes, macros, and DOCX formatsIntuitive Mail Merge wizard for easier data source integrationLightweight application that processes large data files without laggingBuilt-in robust proofing and formatting tools for polished outputs

microsoft office alternative - wps office

Frequently Asked Questions

Why do links lose their clickable format inside an IF field?

By design, field logic engines evaluate the result as raw text. When a hyperlink is generated as the output of an IF field, the underlying hyperlink metadata is stripped during the mail merge process, leaving only the display text.

Do I need to type the curly braces for field codes manually?

No, you must never type the curly braces { } using standard keyboard brackets. Field braces must be inserted by pressing Ctrl+F9 (or Cmd+F9 on Mac); otherwise, the software will treat them as standard text rather than a functional field code.

Can I use VBA to automate the hyperlink conversion after the merge?

Yes. A VBA macro can be executed on the newly merged document to loop through the text, identify strings formatted like URLs, and apply the AutoFormat command to instantly turn them into active hyperlinks.

Document & File Issues