I need to remove rows in a table where the Merge field is empty

WordMonkey1 · #1 10-27-2020, 02:06 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Template - remove blank rows in a table	Litmus	Mail Merge	16	03-23-2022 01:42 PM
Macro that deletes all empty rows in selected table	MathiasFC	Word VBA	2	02-10-2019 04:06 PM
Mail merge: remove empty rows when a field is not showed	Yarikh	Mail Merge	4	09-23-2018 12:17 AM
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