Microsoft Office Forums Hyperlinks in IF...THEN Mail Merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 12-15-2015, 09:50 PM
macropod's Avatar
macropod macropod is offline Hyperlinks in IF...THEN Mail Merge Windows 7 64bit Hyperlinks in IF...THEN Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

See attached demonstration field code. You should be able to simply copy & paste it into your own document.
Attached Files
File Type: docx Conditional Hyperlink.docx (22.1 KB, 24 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #17  
Old 12-16-2015, 07:52 AM
ljg713 ljg713 is offline Hyperlinks in IF...THEN Mail Merge Windows 7 64bit Hyperlinks in IF...THEN Mail Merge Office 2010 64bit
Novice
Hyperlinks in IF...THEN Mail Merge
 
Join Date: Dec 2015
Posts: 20
ljg713 is on a distinguished road
Default

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!
Reply With Quote
  #18  
Old 12-16-2015, 02:56 PM
macropod's Avatar
macropod macropod is offline Hyperlinks in IF...THEN Mail Merge Windows 7 64bit Hyperlinks in IF...THEN Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #19  
Old 12-16-2015, 11:35 PM
gmayor's Avatar
gmayor gmayor is offline Hyperlinks in IF...THEN Mail Merge Windows 10 Hyperlinks in IF...THEN Mail Merge Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,799
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Quote:
Originally Posted by ljg713 View Post
Thank you very much Graham!

Will this work if I need to share the document with several other people, who won't have this add in on their version of word. I can download it, but I don't think having 10+ people also download it to see the hyperlinks is a great solution for me.
I think you have missed the point of the add-in, which is to insert the hyperlink field format in the merge document. It is not required by others who need to see the document.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

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
Hyperlinks in IF...THEN Mail Merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM


All times are GMT -7. The time now is 04:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft