Multiple Conditional Characters in Mailmerge
Works perfectly, thanks!
"macropod" wrote:
Hi Tim,
Coding your fields like the following should work:
{IF{MERGEFIELD Child_First_4} "" "{MERGEFIELD Child_First_1}, {MERGEFIELD
Child_First_2}, {MERGEFIELD Child_First_3} & {MERGEFIELD Child_First_4}"
{IF{MERGEFIELD Child_First_3} "" "{MERGEFIELD Child_First_1}, {MERGEFIELD
Child_First_2}, & {MERGEFIELD Child_First_3}" {IF{MERGEFIELD
Child_First_2} "" "{MERGEFIELD Child_First_1}, & {MERGEFIELD
Child_First_2}" {MERGEFIELD Child_First_1}}}}
Cheers
"Tim Whitley" wrote in message
...
Here's the problem:
I have four "first name" fields that I want to appear in a specific format
based upon if the contents are null. I would like them to appear in the
following formats depending upon if the next field is not empty.
Child_First_1
or Child_First_1 & Child_First_2
or Child_First_1, Child_First_2 & Child_First_3
or Child_First_1, Child_First_2 , Child_First_3 & Child_First_4
I keep messing up the formatting of the IF statement. Any help would be
appreciated.
|