|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Post sample Word and Excel docs so we can see how you have structured your input docs.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
||||
|
||||
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 |
#4
|
|||
|
|||
Quote:
|
#5
|
|||
|
|||
Quote:
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word Macro: How to automatically add hyperlinks to timestamp texts? | loklokpanda | Word VBA | 0 | 02-12-2023 09:22 AM |
Creating Hyperlinks after a Mail Merge | jeffreybrown | Mail Merge | 4 | 09-19-2017 06:35 PM |
Hyperlinks in IF...THEN Mail Merge | ljg713 | Mail Merge | 18 | 12-16-2015 11:35 PM |
Batch edit mail merge macros? | kbash | Word | 0 | 04-30-2014 08:32 AM |
Mail merge from Excel to Word and include hyperlinks | chay | Mail Merge | 5 | 09-28-2013 01:16 AM |