Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Blank Rows in Table populated through Conditional IF statemement MergeField options in Word
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2016, 12:21 PM
gideonpm gideonpm is offline Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Windows 8 Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Office 2013
Novice
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word 		 
Join Date: Dec 2016
Posts: 2
gideonpm is on a distinguished road
Default 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
Operating Unit Name
OU 18
Associated Components
Component Name
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






Attached Images
File Type: jpg Capture.JPG (103.5 KB, 18 views)
Reply With Quote
  #2  
Old 12-22-2016, 12:35 PM
macropod's Avatar
macropod macropod is offline Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Windows 7 64bit Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote
  #3  
Old 12-22-2016, 12:40 PM
gideonpm gideonpm is offline Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Windows 8 Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Office 2013
Novice
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word 		 
Join Date: Dec 2016
Posts: 2
gideonpm is on a distinguished road
Default
Thanks Paul, Can you provide more details on the Words mail merge Filters
Reply With Quote
  #4  
Old 12-22-2016, 01:20 PM
macropod's Avatar
macropod macropod is offline Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Windows 7 64bit Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word 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
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word 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
Blank Rows in Table populated through Conditional IF statemement MergeField options in Word Count rows and add blank rows accordingly Hoochtheseal Word VBA 1 01-29-2013 09:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft