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 / February 2006

Tip: Looking for answers? Try searching our database.

Supressing in a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michele - 02 Feb 2006 21:48 GMT
Is it possible to suppress in a table that consists of 3 columns and 1 row?  
For example, in Col 1, we have several conditional statements for the
mailmerge and similar statements in Col 3 which reflects dollar amounts (Col
2 is blank).  Ideally, we want to suppress the entire "visual" line if the
subject is n/a or $0.  So if someone is not getting a salary increase, we
want to completely remove it.  For example, right now it is:

Current Salary:                $XX,XXX
Salary Increase Amt:        $X,XXX
New Salary:                     $XX,XXX
Bonus:                             $X,XXX
Total Comp:                     $XX,XXX

But if there is not salary increase we want the table to reflect:

Current Salary:                $XX,XXX
New Salary:                     $XX,XXX
Bonus:                             $X,XXX
Total Comp:                     $XX,XXX

Is this something we need to break into several rows in order to suppress
correctly?
Doug Robbins - Word MVP - 03 Feb 2006 05:03 GMT
You cannot, using mail merge, eliminate a row from a table.  You can
however, using If...then...Else fields, supress the display of unwanted
information and have the subsequent information moved up to take its place.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Is it possible to suppress in a table that consists of 3 columns and 1
> row?
[quoted text clipped - 20 lines]
> Is this something we need to break into several rows in order to suppress
> correctly?
 
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.