Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2003

Tip: Looking for answers? Try searching our database.

Merge Using IF statement

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Debbie - 06 Aug 2003 21:30 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.