hyperlink created in excel using =hyperlink not merging in mail merge as hyperlink

Question

Hello,

In excel I have created a hyperlink using =HYPERLINK(link location, friendly name)

When I run a mail merge in word this merges as plain text.

For example in excel the url might be https://answers.microsoft.com/en-us and with the =hyperlink formula there would be a clickable link to the url but showing the text you indicated, such as:

Ask Microsoft Community

However when doing a mail merge this just shows up as plain text! How can I get the hyperlink to merge to the Word document?

Answer 1

Found the answer at:

https://support.microsoft.com/en-us/topic/using-mail-merge-fields-within-hyperlinks-59e6a806-8de1-86ce-32d9-9b2a7d98df1a

but it's a long process ...Microsoft needs a more streamlined way to do this!

Answer 2

You can post feedback for Microsoft using the feedback facility in your version of Word.