Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 09-22-2017, 03:09 PM
macropod's Avatar
macropod macropod is offline Nesting Merge Fields Windows 7 64bit Nesting Merge Fields 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

I've tracked the problem down to the presence of the year # in the IF test. You can overcome that by replacing 2017 with ????, as in:
{IF{MERGEFIELD Fund_description_1} = "???? Fund_Arts" "ARTS"}{IF{MERGEFIELD Fund_description_1} = "???? Fund _Athletics" "ATHLETICS"}{IF{MERGEFIELD Fund_description_1} = "???? FUND_Financial Aid" "FINANCIAL AID"}
or:
{IF{MERGEFIELD Fund_description_1} = "???? Fund_Arts" "ARTS" {IF{MERGEFIELD Fund_description_1} = "???? Fund _Athletics" "ATHLETICS" {IF{MERGEFIELD Fund_description_1} = "???? FUND_Financial Aid" "FINANCIAL AID"}}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Nesting Merge Fields Mail Merge fields merge incorrectly and won't fix. marym Mail Merge 3 04-09-2016 05:17 AM
Nesting Merge Fields Displaying FORMTEXT fields when merge fields are empty or null sfkHooper Mail Merge 6 01-19-2016 04:24 PM
Nesting and IF & AND statement lynchbro Excel 4 04-16-2015 11:39 AM
Nesting Merge Fields merge fields disappear in merge doc but prints mdod Word 1 07-19-2013 06:33 PM
Nesting Merge Fields Nesting Variables SET, LISTNUM, and REF Wyskers Word 1 11-13-2011 05:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 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