Nested If then else Mail Merge

[ac66bronco]

Hey all need some probably simple help.

I need to do a mail merge with 3 conditions.

The excel file cell will have either B1 B2 or Both entered

If B1 I want the out put to be

Two Years most recent Federal Tax Returns and all supporting W-2s Tom Jones

If B2 I want the out put to be

Two Years most recent Federal Tax Returns and all supporting W-2s Brenda Jones

If Both I would obviously like

Two Years most recent Federal Tax Returns and all supporting W-2s Tom Jones & Brenda Jones

This is what I have for both but I am probably way off from a solution.

{ IF { MERGEFIELD Two_Years_most_recent_Federal_Tax_Return = "Both" "Two
Years most recent Federal Tax Returns and all supporting W-2s" ""}
{ IF { MERGEFIELD BrnApp_} = "Both" "Two Years most recent Federal Tax Returns and all
supporting W-2s" { MERGEFIELD "Borrower Name" }{ MERGEFIELD "Borrower Name 2"}
""}

As always any help is greatly appreciated.

 

[Macropod]

Please read what I said in the Note in post #3. You need to use the Insert mergefield dropdown for each & every string between chevrons.