Problem with Mixing names

[Jon]

This is probably basic, but I can't figure it out. I have an Excel list
containing names of donors, amounts, addresses, etc. For some of these I have
a title, i.e. Mr., but for others nothing. Others have provided the names of
both spouses. I'm creating a letter acknowledging their contribution.
Apparently because I don't have titles for everyone at some point the letters
start mixing the first names of one donor with the last name of another. How
can I prevent this? Thanks for your patience.

 

[Graham Mayor]

You need to use conditional fields eg

{IF{Mergefield Title} <> "" "{Mergefield Title} "}{Mergefield FirstName}
{Mergefield LastName}
or
{IF{Mergefield Title} <> "" "{Mergefield Title} {Mergefield LastName}"
"{Mergefield FirstName} {Mergefield LastName}"}

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


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