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]

Paul, this code is magic. Just curious, can you think of any way to do the same thing for an email merge. Realize the macro as written works on the merged file as an individual document.



Appreciate any help you can offer as I have been looking for a solution to this challenge for quite a while!

No, because there's no post-merge 'document' to process.

Depending on what you're doing and how your data are configured, though, you might be able to
• use a DATABASE field. See, for example: Many to one email merge using tables - Microsoft Community ; or
• use IF tests with multiple versions of the table embedded within. See, for example: https://www.msofficeforums.com/128352-post6.html

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

Thanks for the quick reply and great ideas, Paul! Is it possible to parse the Individual Documents into an email merge by adding the email address --a two step process?