Using if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Boots - 02 Jun 2006 13:19 GMT

Hi,
In my merge I have a field "ETHNICITY". This is a number at the minute.
ie 01, 02 etc. I would like to show the Name of the ETHNICITY rather than
the code. How could I do this?
I have 17 codes.

Thanks

Reply to this Message

macropod - 02 Jun 2006 13:40 GMT

Hi Boots,

I'd recommend adding a column to your data source to represent what those 17
codes mean. Otherwise, you're going to need 17 IF fields in your mailmerge
document, each coded along the lines of:
{IF{MAILMERGE ETHNICITY}= 1 "Yankee"}
where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9. You
could get away with 16 nested IF fields, but 17 independent ones make more
sense in this case (easier to follow/debug).

Cheers

Signature

macropod
[MVP - Microsoft Word]

> Hi,
> In my merge I have a field "ETHNICITY". This is a number at the minute.
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

Graham Mayor - 02 Jun 2006 15:30 GMT

Note that the 17 conditional fields all go on the same line (allowing Word
to wrap) with no spaces between them.

Signature

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

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

> Hi Boots,
>
[quoted text clipped - 15 lines]
>>
>> Thanks

Reply to this Message