Multiple conditional mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sue - 15 Mar 2004 07:43 GMT

Hi.

Hope someone can assist me.

Can Word accept more than 3 multiple conditional mail
merge? I have a letter that requires a statement that
contains 4 conditions. I use the {IF}, Value = 1,
COMPARE, = AND fields. I can setup 3 "compare" conditions
but on the 4th condition it will not merge to letter.
Could someone please give me the formula or explanation as
to what I'm doing wrong?

e.g.

When all four of the following conditions are met insert
the Clause 1 below.

MERGEFIELD a27 > 0
MERGEFIELD a36 = N
MERGEFIELD m17 > 13/12/1938
MERGEFIELD m47 <> 2

{if {=AND ({compare {merge field A27} <> 0}, { = AND
({compare{mergefield A36} = N}, {= AND ({compare
{mergeield M47} <>2}, {compare {mergefieldm17} >7600)})})}
= 1 "you have etc etc etc"""}

I have a statement that has 5 conditions but I hope
solving the above statement would be a matter of insertin
another condition without the "and" field?

Reply to this Message

Graham Mayor - 15 Mar 2004 08:59 GMT

The problem is likely to be the date field.
Try this instead:

{IF {Mergefield a27} > 0 "{IF {Mergefield a36} = "N" "{IF {Mergefield M17 \@
"yyyyMMdd"} > 1938123 "{IF {Mergefield m47} <> "2" "You have this etc..."
""}" ""}" ""}" ""}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hi.
>
[quoted text clipped - 26 lines]
> solving the above statement would be a matter of insertin
> another condition without the "and" field?

Reply to this Message

Sue - 16 Mar 2004 00:16 GMT

Hi Graha

Thanks for your reply. However the suggested formula didn't work. I have inserted the statement with your suggested formula. The error message is a "field calculation error". I have updated my formula. I would appreciate your assistance further or anyone else's

MERGEFIELD a27 >
MERGEFIELD a36 = N
MERGEFIELD m17 > 13/12/193
MERGEFIELD m47 <>

{IF {Mergefield a27} > 0 "{IF {Mergefield a36} = "N" "{IF {Mergefield M17 \
"yyyyMMdd"} > 7600 "{IF {Mergefield m47} <> "2" "You have 3 insurance unit(s) with your Award Plus Plan account. The insured lump sum benefit is payable on death or total and permanent disablement. For APP insurance purposes your classification is Class 1. Please see our Super Informed newsletter for information on the classifications." ""}" ""}" ""}" ""

Reply to this Message

Sue - 16 Mar 2004 00:51 GMT

Graham

We've got the formula working! THANK YOU!!
Regard
Sue

Reply to this Message

Graham Mayor - 16 Mar 2004 07:50 GMT

I take it that it was the date calculation that was amiss?
the number you were referencing was 7600 whereas it should have been
19381213. See
Testing for events that occur before or after a certain date in
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Graham,
>
> We've got the formula working! THANK YOU!!
> Regards
> Sue

Reply to this Message