Multiple Conditional Characters in Mailmerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Whitley - 22 Apr 2006 01:19 GMT

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.

Reply to this Message

macropod - 22 Apr 2006 07:31 GMT

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

> Here's the problem:
>
[quoted text clipped - 9 lines]
> I keep messing up the formatting of the IF statement. Any help would be
> appreciated.

Reply to this Message

Tim Whitley - 23 Apr 2006 20:24 GMT

Works perfectly, thanks!

> Hi Tim,
>
[quoted text clipped - 21 lines]
> > I keep messing up the formatting of the IF statement. Any help would be
> > appreciated.

Reply to this Message