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.