Thread: [Solved] Nesting Merge Fields
View Single Post
 
Old 09-22-2017, 03:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
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