[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

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



Jon wrote:
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.