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 / November 2004

Tip: Looking for answers? Try searching our database.

Rooming List If ..then

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rick - 05 Nov 2004 05:17 GMT
I am using merge fields to do tour lists. I have two clients in each
reservation cell. When I want to make a list I have asked for both names to
appear on the list. The problem is when I have a file that only has one name
say a single occupancy, how do I get the list to ignore the second name
(which is empty) and only show the first one.
How do I tell the merge document If ... is empty...don't list this section
of the file.

Rick
Cindy M  -WordMVP- - 10 Nov 2004 19:20 GMT
Hi Rick,

> I am using merge fields to do tour lists. I have two clients in each
> reservation cell. When I want to make a list I have asked for both names to
[quoted text clipped - 3 lines]
> How do I tell the merge document If ... is empty...don't list this section
> of the file.

If you mean, how can you suppress empty characters at the end of a field (table
cell) coming across from the data source, I'm afraid there's not much chance.
Better would be to split things up into two columns. Then you can use an IF
field to suppress display of the second one, if it's empty.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Rate this thread:






 
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.