Tables - all or most cells have data condition?

J

Jules

Hi,

I have autotext tables with 2 3 4 5 columns. - One table will be selected. I need to know if all (or most) cells have data in table as condition before email macro allows the document to be sent.



If too many cells are blank - user sees msgbox ask Please complete table before emailing document.



Can anyone help please?



Have a great day!
 
J

Jules

I worded that badly. There will be one table on the page at any given time (at this point). So it will always be Table(1).

Hi,

I have autotext tables with 2 3 4 5 columns. - One table will be selected. I need to know if all (or most) cells have data in table as condition before email macro allows the document to be sent.



If too many cells are blank - user sees msgbox ask Please complete table before emailing document.



Can anyone help please?



Have a great day!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top