Mr and Mrs

[steve]

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?

 

[Graham Mayor]

You need conditional fields - something along the lines

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


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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>