Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Conditional Characters in Mailmerge
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Conditional Characters in Mailmerge
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use multiple worksheets when doing a mailmerge | Mailmerge | |||
Mailmerge location per page with multiple employees | Mailmerge | |||
email address truncated to 24 characters with mailmerge to Lotus Notes | Mailmerge | |||
Multiple mailmerge documents open | Mailmerge | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge |