Hi Community,



I encounter some difficulties in developing a Word macro that can mail merge hyperlinks from Excel to Word document's textboxes.

For example, there is a textbox with texts "1234" in a Word Document. An Excel file contains 2 columns, column A is the texts need to add hyperlinks, column B is the hyperlinks (URL)

E.g., Cell A2 = 1234; Cell B2 = Google

How to write a macro that can automatically add hyperlinks from Excel to Word textboxes? I tried to find similar Word VBA codes in a lot of posts in different forums related to VBA but in vain.

Your help will be greatly appreciated.

Post sample Word and Excel docs so we can see how you have structured your input docs.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

You may find Hyperlink Merge Fields useful.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thank you gmayor. I tried but the add-ins cannot recognize the text in the textbox.

Thanks for your reply. Please see the attached files below:

test.xlsx

test.docx

I would like to find a macro that can automatically add hyperlinks from this excel file to the Word's text in the textbox.