Problem with Mixing names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 21 Nov 2007 14:55 GMT

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.

Reply to this Message

Graham Mayor - 21 Nov 2007 15:25 GMT

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}"}

Signature

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

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

> 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
[quoted text clipped - 4 lines]
> names of one donor with the last name of another. How can I prevent
> this? Thanks for your patience.

Reply to this Message