ac66bronco
New Member
- Joined
- Dec 10, 2014
- Messages
- 44
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.
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.