#16
|
||||
|
||||
See attached demonstration field code. You should be able to simply copy & paste it into your own document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#17
|
|||
|
|||
It worked Thank you!
One final tangential question. I have one other link in the document where the text is not variable and should be the same in every mail merge, but the link changes. I input a hyperlink the regular way, and then replaced everything after the hyperlink with inserting a merge field, and it works while I remain in the document. However, everytime I reopen the document after closing it, the merge field is no longer a part of the hyperlink, and it only links to the first link throughout all the documents. Any idea why it is not retaining the merge field upon saving, closing, and reopening? Also, when I closes, the links change so instead of http://www..... they are some how connected with my computer so when I hover over them they say "file:///c:\username\documents\http:.....", and some of them don't even work. When I alt + f9, there are "%20"'s within the links. Several of the links are to online pdfs (.pdf). Perhaps this is the issue. If so, I would love to know if there is a workaround. Thanks again! Cheers! |
#18
|
||||
|
||||
That problem may be due to the way you've structured the hyperlink. Without seeing the actual field code, I can't really say, but having "file:///c:\username\documents\http:....." is a fair indication of a problem - one doesn't expect to see both 'file' and 'http' in a hyperlink. You may be able to work around the problem by not updating fields in the document before merging (e.g. don't do a preview).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#19
|
||||
|
||||
Quote:
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
hyperlink, hyperlink in mail merge, mailmerge |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge is Deleting objects in my header and footer during the merge | bgranzow | Mail Merge | 9 | 06-05-2015 05:03 AM |
Mail merge how to link mail merge field value to a column heading | dsummers | Mail Merge | 1 | 05-08-2014 02:59 PM |
E-Mail attachment (PDF) opening up Hyperlinks instead of PDF | slee | Outlook | 0 | 11-06-2013 07:29 PM |
Mail merge from Excel to Word and include hyperlinks | chay | Mail Merge | 5 | 09-28-2013 01:16 AM |
Saving INDV mail merges During the mail merge | sedain121 | Mail Merge | 2 | 10-04-2011 07:52 PM |