View Single Post
 
Old 03-03-2023, 02:39 AM
syl3786 syl3786 is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Jan 2023
Posts: 97
syl3786 is on a distinguished road
Default How to use Word Macros to mail merge hyperlinks to the texts in textboxes?

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.
Reply With Quote