![]() |
|
#1
|
|||
|
|||
![]()
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) |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Combine "sort within groups" and "identify duplicate/unique values" in two different variables. | civilcervant | Excel | 3 | 06-12-2017 07:27 AM |
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N | mikey386 | Excel | 2 | 12-11-2014 01:14 PM |
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas | jocke321 | Word VBA | 2 | 12-10-2014 11:27 AM |
![]() |
Eri | Mail Merge | 1 | 03-03-2012 03:03 PM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |