Quote:
Originally Posted by bgranzow
The problem is that whether the row is filled or not depends on a number of variables in the records I am sinking. And at over 300 records, manual deletion would be a pain. Does anyone know how to write the VBA code for the Hidemark property?
|
I wasn't suggesting manual deletion - it can be done quite easily with a macro. I also suggested you might consider re-doing the mailmerge so it only creates those rows you actually require.
The code provided by jpb103 will
delete (not just hide) the entire row if even just the first cell on the row is empty. It's not clear whether that's what you want, or whether the entire row must be empty.
At this stage, you haven't provided enough information for anyone to know what kind of table your mailmerge generates. For example, do the number of records for each table vary, or is it that some records have empty fields. If it's the former, a Directory merge may be the way to go, instead of the Letter merge you're now using.