create conditional data in label mail merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Corky Whiteboard - 15 Sep 2005 15:30 GMT

I have a mail merge label document. I want to conditionally print one field
- ie, if the <<Country Abbrev>> field is NOT US, then print the <<Country>>
field otherwise leave blank.

Signature

Corky

Reply to this Message

larrynospam@nospamjbmsystems.com - 15 Sep 2005 17:13 GMT

HI,

If you have a fairly large volume to process and would like an automated
solution, my OctoTools can conditionally print based on input information
(such as state code or zip or phone number or any other input data as well).
OctoTools is however more justified for applications running with medium to
high volume throughputs as opposed to an occasional desktop app. If
interested please give me a call (978) 535-7676 or e-mail for additional
info.

Thanks and good luck,

Larry T.

Reply to this Message

Graham Mayor - 16 Sep 2005 06:02 GMT

{IF {Mergefield Country_Abbrev} <> "US" "{Mergefield Country}"}
will do that. Note that the field boundaries {} are inserted with CTRL+F9
and that fieldnames should not have spaces.
however if the fieldname does have a space, it might work with
{IF {Mergefield "Country Abbrev"} <> "US" "{Mergefield Country}"}

See http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a mail merge label document. I want to conditionally print
> one field - ie, if the <<Country Abbrev>> field is NOT US, then
> print the <<Country>> field otherwise leave blank.

Reply to this Message