|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word
Attached is the snap shot of field Codes in table format. The issue we are facing is for the rows in the table which does not meet the condition in IF statement a blank row is inserted. Can we suppress those blank lines, see the output below
Associated Organizational Unit OU 18 Associated Components Confidentiality Integrity Availability Overall Security Category 181-04 CPI Moderate Moderate Low Moderate 181-04 IBX Moderate Moderate Moderate Moderate 181-04 LB Moderate Moderate Moderate Moderate 181-04 ISE Moderate Moderate Moderate Moderate 181-04 NN Moderate Moderate Moderate Moderate 181-04 NNA Low Low Low Low 181-04 OOBF Moderate Moderate Moderate Moderate 181-04 RS Moderate Moderate Moderate Moderate 181-04 TE Low Low Low Low 181-04 UPS Moderate Moderate Moderate Moderate 181-04 WAP Moderate Moderate Moderate Moderate |
#2
|
||||
|
||||
You appear to be using a third-party product for your mailmerges, not just Word's mailmerge tools. What you can achieve will be limited by that product's abilities. That said, you may be able to circumvent the issue by applying Word's mailmerge filters to filter the records so that only those meeting your 'Operational' criteria are processed. In that case, you also won't need the IF tests.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Paul, Can you provide more details on the Words mail merge Filters
|
#4
|
||||
|
||||
The filtering is done via Mailings|Edit Recipient List>Filter. In this case, I believe you would set the
• 'field' to 'OperationalStatus' • 'comparision' to 'equal to' • 'compare to' to 'Operational'.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Delete blank rows between the two rows that contain data | beginner | Excel Programming | 5 | 12-26-2014 12:29 AM |
Is it possible to copy non-contiguous rows of a Table and paste them as a separate Table in Word? | Joey Cheung | Word Tables | 1 | 08-12-2014 05:15 PM |
Grouping table rows to prevent individual rows from breaking across pages | dennist77 | Word | 1 | 10-29-2013 11:39 PM |
Table with Conditional Format to Word | billyV | Excel | 9 | 06-07-2013 08:26 AM |
Count rows and add blank rows accordingly | Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |