Mail Merge Template - remove blank rows in a table

		Microsoft Office Forums > Microsoft Word > Mail Merge
Mail Merge Template - remove blank rows in a table

FAQ

Thread Tools

Display Modes

01-10-2019, 01:28 PM

macropod

Windows 7 64bit Mail Merge Template - remove blank rows in a table

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,385

Quote:

Originally Posted by Litmus

A quick question - will it work with more columns of data re:
For r = .Rows.Count To 3 Step -1
if I had say six columns maybe - please excuse my VBA ignorance

The line:
For r = .Rows.Count To 3 Step -1
refers to rows, not columns. As coded, the macro tests column 2 (via the .Cells(2) reference). Provided that column is empty, the row will be deleted; the number of columns (provided there are at least 2) is of no consequence.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to remove almost a full page of blank space in between Word table rows	garrisonsdad	Word Tables	4	10-18-2018 09:09 PM
Mail merge: remove empty rows when a field is not showed	Yarikh	Mail Merge	4	09-23-2018 12:17 AM
Remove blank table rows AFTER mailmerge	Formd	Mail Merge	5	05-11-2018 03:43 PM
How to remove blank spaces between rows in a table,	Jamal NUMAN	Word	2	04-28-2017 12:59 PM
Mail merge into table with two colums and several rows	kathriiin	Mail Merge	3	03-30-2015 07:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 AM.