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.