If this has anything to do with mailmerge, which isn't apparent from your post despite being posted in the mailmerge forum, see
Mailmerge Hyperlink ‘Click Here’ Insertion in the
Mailmerge Tips and Tricks sticky thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html