Well, I was able to get the following to work. I know it's not the best way.
{IF{MERGEFIELD Rep}= "" {IF{={IF«Role»= "Rec*" 1 0}+{IF«Role»= "Rpt*" 1 0»+{IF«Role»= "Ord*" 1 0} \# 0}> 0 «Address» }} {IF{MERGEFIELD Rep}<> "" {IF{={IF«Role»= "Rec*" 1 0}+{IF«Role»= "Rpt*" 1 0»+{IF«Role»= "Ord*" 1 0} \# 0}> 0 «AltAdd»}}
There is still a missing piece to the puzzle.
{IF{MERGEFIELD Rep}<> "" {IF{={IF«Role»= "Rec*" 1 0}+{IF«Role»= "Rpt*" 1 0»+{IF«Role»= "Ord*" 1 0} \# 0}> 0 «AltAdd»}}
This should include MERGEFIELD «Altname» + «AltAdd».Only «AltAdd» merges. When I include both fields only one merges.
Final product should have
Joe Blo (this would be the Altname field)
8901 Coral Ave, New York, NY 22222 (this would be the Altadd field)
|