Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-22-2016, 12:21 PM
gideonpm gideonpm is offline Windows 8 Office 2013
Novice
 
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, 5 views)
Reply With Quote
  #2  
Old 12-22-2016, 12:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 14,903
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all
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
[MS MVP - Word]
Reply With Quote
  #3  
Old 12-22-2016, 12:40 PM
gideonpm gideonpm is offline Windows 8 Office 2013
Novice
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 14,903
macropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to allmacropod is a name known to all
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
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 01:57 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft