How to Make Concatenated URLs Clickable in Word Mail Merge
Question details
Users need a method to ensure URLs remain clickable when performing a mail merge using concatenated fields from an Excel data source.

- Product
- Microsoft Word, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Performing an Excel-to-Word mail merge where URLs are combined with other text and line breaks in a single field.
- Observed behavior
- The inserted URLs appear as plain text instead of clickable hyperlinks in the merged document or email body.
Verify your Excel data source contains valid URLs starting with 'http://' or 'https://' and consider making a copy of your document before applying structural changes.
Store the URL in a Separate Excel Column
The most reliable method for preserving hyperlinks in a native mail merge is to isolate the URL into its own dedicated field before merging.
Word's standard mail merge struggles to parse partial hyperlink formatting from a mixed text string. By keeping the URL in an independent column, you can utilize Word's specific field codes to enforce clickable link generation.
Open your Excel data source and insert a new column specifically for your URLs.
Remove the URL strings from your original concatenated text fields and paste them into the new dedicated URL column.
In your Word document, press Ctrl+F9 to insert a blank field code, then type HYPERLINK followed by the new URL merge field (e.g., HYPERLINK "{MERGEFIELD YourURLColumn}").
Press Alt+F9 to toggle the field codes back to normal view, preview your results, and complete your mail merge.
Use a VBA Macro to Convert Plain Text to Links After Merging
If you cannot modify your Excel data source to separate fields, you can run a macro on the final merged Word document to recognize and convert URLs.
Merge to PDF Attachments Using an Add-in
For email distribution, converting the merged document to a PDF attachment can bypass email body plain-text limitations.
Try WPS Office for Seamless Document Creation
Since concatenated URL formatting is a known limitation in standard Office Mail Merge, consider exploring WPS Office. It provides a familiar interface, highly compatible word processing tools, and is completely free to use.

Frequently Asked Questions
Why do my hyperlinks disappear during a Word mail merge?
Standard mail merge processes data from Excel as plain text. If a URL is mixed with regular text in a single concatenated field, the word processor applies uniform plain text formatting to the entire block, removing the clickable link property.
Can I format just the URL inside a concatenated merge field?
No. Native mail merge applies formatting to the entire merge field at once. You cannot isolate and format a specific part of a concatenated text string to be a hyperlink using standard Word features.
Does merging directly to HTML emails preserve links?
Merging complex concatenated fields directly into an email body often results in plain text output. Storing the URL in its own independent field or merging the document to a PDF attachment is recommended for guaranteeing the preservation of clickable links.




