Mr and Mrs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve - 08 Oct 2004 06:56 GMT

Currently our mail merge from Access2000 reads in the
document say whereas fields 1 & 3 are Prefix Mr, Mrs etc,
and fields 2 & 4 are last name.

(field 1)(field 2)
(field 3)(field 4)

Dear (field 1) (field 2),

xxxxxxxxxxx

What we want it to read is:

(field 1)(field 2)
(field 3)(field 4)

Dear (field 1)(field 2)and(field 3)(field 4),

xxxxxxxxx

whereas the "and" disappears when field 3 or 4 are Null.

How do I do that?

Reply to this Message

Graham Mayor - 08 Oct 2004 08:31 GMT

You need conditional fields - something along the lines

Dear (Mergefield 1} (Mergfield 2}{IF {Mergefield 4} <> "" " and {Mergefield
3} {Mergefield 4}" }

Signature

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

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

> Currently our mail merge from Access2000 reads in the
> document say whereas fields 1 & 3 are Prefix Mr, Mrs etc,
[quoted text clipped - 19 lines]
>
> How do I do that?

Reply to this Message