Fix Word Mail Merge Hyperlink Field Not Activating in Output Documents

You have a Word mail merge document with a hyperlink field, but when you finish the merge, the resulting hyperlinks appear as plain text and do not open a web browser when clicked. This problem occurs because Word does not automatically update the hyperlink field codes in the merged output; the field codes remain in their pre-merge state. This article explains the root cause of the issue and provides a step-by-step fix using a macro to convert the field codes into active hyperlinks in the final document.

Why Mail Merge Hyperlink Fields Stay Inactive in the Output

When you create a mail merge document in Word, you insert a hyperlink field using the Insert > Link > Link dialog or by typing the field code directly. The hyperlink field code looks something like this:

{ HYPERLINK “https://example.com/{MERGEFIELD URL}” }

During the merge, Word replaces the MERGEFIELD part with the actual data from your data source. However, Word does not execute the HYPERLINK field code in the merged output. The field code remains as a field code, not as an active hyperlink. This means the text appears underlined and blue, but Ctrl+click or single-click does not open the link. The problem is not a bug; it is by design. Word treats the merged document as a snapshot of the field codes, not as a final formatted document unless you manually update the fields.

Steps to Activate Hyperlinks in the Mail Merge Output Document

The most reliable method to activate all hyperlinks in the merged document is to use a short VBA macro. This macro runs after the merge and converts every HYPERLINK field into a working hyperlink.

1. Complete the mail merge and create the output document
   On the Mailings tab, click Finish & Merge, then select Edit Individual Documents. In the dialog, choose All and click OK. Word creates a new document containing all merged records. Do not close this document.
2. Open the Visual Basic for Applications editor
   Press Alt+F11 to open the VBA editor. If the editor does not open, check that macros are enabled in File > Options > Trust Center > Trust Center Settings > Macro Settings. Select Enable all macros temporarily, then revert after running the macro.
3. Insert a new module
   In the VBA editor, go to Insert > Module. A blank code window appears.
4. Paste the hyperlink activation macro
   Copy and paste the following code into the module window:
   Sub ActivateHyperlinksInMerge()
Dim doc As Document
Dim fld As Field
Set doc = ActiveDocument
For Each fld In doc.Fields
If fld.Type = wdFieldHyperlink Then
fld.Update
End If
Next fld
MsgBox "All hyperlink fields updated."
End Sub
5. Run the macro
   Press F5 while the cursor is inside the macro code, or go to Run > Run Sub/UserForm. A message box confirms that all hyperlink fields have been updated. Close the VBA editor.
6. Save the output document
   Save the merged document as a Word Macro-Enabled Document (.docm) or as a standard .docx file. The hyperlinks are now active. Test a few links by Ctrl+clicking them.

Alternative Method: Update All Fields Manually

If you prefer not to use a macro, you can update all fields in the merged document manually. However, this method is impractical for documents with many records because it updates every field type, not just hyperlinks.

1. Select the entire document
   Press Ctrl+A to select all content.
2. Update fields
   Press F9. Word updates all fields, including hyperlink fields. This method works but can be slow for large documents.

If Hyperlinks Still Do Not Work After Updating

Hyperlinks appear as plain text with braces

If you see the literal field code text such as { HYPERLINK “https://…” } in the output document, the field code display is turned on. Press Alt+F9 to toggle the display back to the hyperlink result. The braces disappear and the link becomes clickable.

Hyperlinks open the wrong URL or no URL

This usually means the MERGEFIELD data contained an empty value or a malformed URL. Check your data source for blank cells or incorrect URL formatting. In the mail merge document, you can add a conditional field to skip records with empty URL fields. Use the IF field code: { IF { MERGEFIELD URL } <> “” { HYPERLINK “{ MERGEFIELD URL }” } “No link available” }

Macro does not run in the merged document

If the macro does nothing or you get a security warning, the merged document might be in a trusted location that blocks macros. Save the document to your local Documents folder or a trusted location defined in File > Options > Trust Center > Trust Center Settings > Trusted Locations. Alternatively, temporarily disable macro security as described in step 2.

Mail Merge Hyperlink Activation Methods Comparison

Item	VBA Macro	Manual F9 Update
Description	Runs a macro that updates only hyperlink fields after merge	Selects all content and presses F9 to update every field type
Speed for large merges	Fast — updates only hyperlinks	Slow — updates all fields including page numbers, dates, etc
Requires macro trust	Yes — must enable macros temporarily	No — uses built-in Word command
Preserves other field types	Yes — does not touch non-hyperlink fields	No — updates all fields, which may change calculated values
Best for	Documents with many records where only hyperlinks need activation	Small documents where you want a quick one-time fix

After the merge, you can now open the output document and click any hyperlink to launch the URL in your default browser. The VBA macro provides the most targeted fix without disturbing other field types. For future merges, consider saving the macro in your Normal.dotm template so it is always available. You can also assign the macro to a keyboard shortcut via File > Options > Customize Ribbon > Keyboard shortcuts > Customize for even faster access.