I have my addresses in an Excel file. I've matched the fields for Title,
First, Last, Spouse Title, Spouse First, and Spouse Last - so far so good.
But for couples with different last names, my label does not read (as I would
expect):

Mr. John Doe and Mrs. Jane Smith

I just get:

Mr. and Mrs. John Doe

Does anyone know how to make it do the former, but only in the case where
the couple has different last names?

Thanks,

Robb

For this you need a conditional field construction that will cover all
eventualities thus:

{ IF{ Mergefield Last } { Mergefield "Spouse Last" } "{ IF{ Mergefield
"Spouse Last" } "" "{ Mergefield Title } { Mergefield First} { Mergefield
Last } & { Mergefield "Spouse Title" } { Mergefield "Spouse First" } {
Mergefield "Spouse Last" }" "{ Mergefield Title } { Mergefield First} {
Mergefield Last }" }" "{ Mergefield Title } & { Mergefield "Spouse Title" }
{ Mergefield First} { Mergefield Last } "}

ie
If last name is not equal to spouse last name and if spouse last name exists
enter Mr. John Doe and Mrs. Jane Smith if the spouse last name doesn't exist
enter Mr. John Doe otherwise enter Mr. and Mrs. John Doe

All the fields are inserted by hand using CTRL+F9 for each pair of brackets.
Watch out for spelling errors and spaces and make sure your field names are
correct. If there are spaces in the field names you will need quotes around
them.

--

Graham Mayor - Word MVP

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



Robb wrote:
I have my addresses in an Excel file. I've matched the fields for
Title, First, Last, Spouse Title, Spouse First, and Spouse Last - so
far so good. But for couples with different last names, my label does
not read (as I would expect):

Mr. John Doe and Mrs. Jane Smith

I just get:

Mr. and Mrs. John Doe

Does anyone know how to make it do the former, but only in the case
where the couple has different last names?

Thanks,

Robb