Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page I need to remove rows in a table where the Merge field is empty I need to remove rows in a table where the Merge field is empty
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-27-2020, 02:06 PM
WordMonkey1 WordMonkey1 is offline I need to remove rows in a table where the Merge field is empty Windows 10 I need to remove rows in a table where the Merge field is empty Office 2010
Novice
I need to remove rows in a table where the Merge field is empty 		 
Join Date: Oct 2020
Posts: 3
WordMonkey1 is on a distinguished road
Default I need to remove rows in a table where the Merge field is empty
In the attached Word document I have a table, where information is being pulled by merge fields from Excel.




When I hit Finish & Merge, I would like to have any rows (shaded in the example) removed but leave the formula cell (total amount) intact.


Some company's may have 1 in the SS section, and others will have 10. I have set the table to show 10, but if a company has less than that I would like the lines removed so that there is less white space when I send them a copy.


Please let me know if there is a macro I can add to my master template, that will allow the Finish & Merge to remove blank lines but leave the blank lines between the sections.
Attached Files
File Type: docx Equity Confirmation template Trial.docx (20.2 KB, 16 views)
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to remove rows in a table where the Merge field is empty Mail Merge Template - remove blank rows in a table Litmus Mail Merge 16 03-23-2022 01:42 PM
I need to remove rows in a table where the Merge field is empty Macro that deletes all empty rows in selected table MathiasFC Word VBA 2 02-10-2019 04:06 PM
I need to remove rows in a table where the Merge field is empty Mail merge: remove empty rows when a field is not showed Yarikh Mail Merge 4 09-23-2018 12:17 AM
I need to remove rows in a table where the Merge field is empty Delete Empty Table Rows cltay87 Word VBA 4 02-27-2017 04:23 AM
Mail Merge Empty Data Field Licos101 Mail Merge 2 04-10-2014 06:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:27 AM.

Contact Us - Privacy Statement - Top

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