Hello,
I am running office 2013. In word, I have a table with rows. These rows are filled by a mail merge. Sometimes, the rows are completely empty. When this occurs, I would like the rows to automatically shrink to size 0. Currently they cannot do so because of the hidden next cell glyph in each cell. I know there is a way to use VBA and the HideMark property to tell word to ignore those glyphs when defining the cell height however, I'm not sure how to go about writing the code for it. Please Help. Thank you.



Here is a link to what I need to do.
http://officeopenxml.com/WPhideMark.php

The preferred way of handling this would be to not create the unwanted rows in the first place. How you go about doing that depends on whether you need a variable number of rows or whether some required rows simply have no data (e.g. a row for a cell phone but the record doesn't have one).

The alternative would be to use a macro to delete, not just hide, the rows post-merge.

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

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?

What do you mean by manual deletion? You could just write a macro to delete every row with no data, it shouldn't take that long to process. I personally haven't heard of the Hidemark property until seeing this post.

I'm not sure that a macro that runs post merge will work for our application but can you link me to the code for one and I will work on implementing it and making it work. Thanks.

Just pop a command button on your document and give this code a try:
Keep in mind that this code only checks the first (i.e. leftmost) cell in each row to see if it is empty.
*EDIT* Woops, you can remove the MsgBox line (it's commented out anyways). I was using it for testing.

Great thanks! I'll give this a try and see what I can do to make it work for us.

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.

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