VBA transfer data from excel to word by clicking a hyperlink
I have two documents:
1. Excel document - client list
2. Word document - letter to be sent
Let me start off by saying I do not want a mail merge option for this unless it can be automated.
I want to be able to click a hyperlink in excel and it push cell information into an already created letter.
My excel document has information in columns A, B, D, E, F and G that I want pulled when I click the hyperlink in column H. The trick is that I want the information pushed only to be in the columns of the same row as the hyperlink. Meaning if I click H1, I want the Word document to be filled with the information entered in A1, B1, D1, E1 and G1 but when I click H2 it is filled with the information entered in A2, B2, D2, E2 and G2.
Hopefully someone can help. If you need clarification please let me know. Thanks in advance!
Last edited by JBeaucaire; 06-22-2013 at 06:25 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1