Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #9  
Old 12-15-2015, 02:21 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: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The problem you're having is that you're trying to conditionally display a hyperlink, not vary it. Aside from your field coding being incorrect, Word will always output a hyperlink with such a field (even an ostensibly empty one consisting of just a space). The correct field coding is:
{HYPERLINK "{IF{Mergefield Variable}= "Y" "http://www.google.com" " "}"}
Note the difference in spacing in the field code.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
hyperlink, hyperlink in mail merge, mailmerge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks in IF...THEN Mail Merge 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 AM.


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