I'm using Office XP and am using a database query from
Access as my data source, merging into a letter in Word.
The problem I am having is this:
In the salutation line, I would like to use the Nickname
(Nickname field), if there is one; otherwise, I'd like to
use the First_Name field. I have tried every contortion
of the IF statement, but I still do not get what I'm
looking for. Is there anyone that can help? My boss is
not very open to new ways of doing things, so I've got to
get this working before she decides we should ditch the
database and go back to entering information in 20
different places (drives me crazy!). Thank you VERY much
for your help.
Graham Mayor - 07 Aug 2003 13:50 GMT
{IF {Mergefield Nickname} <> "" "{Mergefield Nickname}" "{Mergefield
First_Name}"}
Use CTRL+F9 to insert the field boundaries.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.dsl.pipex.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
> I'm using Office XP and am using a database query from
> Access as my data source, merging into a letter in Word.
[quoted text clipped - 9 lines]
> different places (drives me crazy!). Thank you VERY much
> for your help.