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 / January 2008

Tip: Looking for answers? Try searching our database.

Mail Merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cweidler - 17 Jan 2008 16:12 GMT
I need to do a catalog mail merge from Excel 2000 into Word 2000.  Here is a
brief example:  «name»
              «addr_1»
              «city», «state»  «zip»
               Phone:  «phone_no_1»
               Fax:  «fax_no»
I need a command/formula for the merge not to print the word "Phone" or
"Fax" if there is not a phone number or fax number listed for that member.
Peter Jamieson - 17 Jan 2008 18:35 GMT
Try

{ IF "{ MERGEFIELD phone_no_1 }" = "" "" "Phone: { MERGEFIELD
phone_no_1 }" }

where /all/ the {} are the special field braces you can insert using
ctrl-F9.

If that does not quite work, try

{ IF "{ MERGEFIELD phone_no_1 }" = "" "" "
Phone: { MERGEFIELD phone_no_1 }" }

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I need to do a catalog mail merge from Excel 2000 into Word 2000.  Here is
>a
[quoted text clipped - 5 lines]
> I need a command/formula for the merge not to print the word "Phone" or
> "Fax" if there is not a phone number or fax number listed for that member.
 
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.