Verify Form Fields, Message if error, Email if no errors

Hello Everyone,
I am looking for code that will verify the date in a certain field is valid. (i.e. nobody uses 99-99-9999) then check the next field that contains a range of checklists that cannot contain blanks. If a blank is discovered then a message pops up stating "Tasks in the checklist are blank. Please complete entire list." and ends the all macros. If all blanks are filled then it will call an email macro that I've already created. The problems I've encountered is that it has to loop through all cells in a range to check for blanks, send the error message AND call the email macro if there aren't any errors. My code seems to call the email macro even if there are errors and it creates several emails.

I haven't been able to find a good way to check the date and have tried several combinations for the other but below are a couple of samples of what I've created.
Sample 1

Please Login or Register  to view this content.

Sample 2

Please Login or Register  to view this content.

Originally Posted by stnkynts

This is challenging to answer in a short and concise manner. Essentially both of your samples have the potential to call the Mail_Form macro multiple times along with other issues. If you are wanting to call the macro one time only if there are no blank cells in the defined range "Form_Task" this will serve you well:

Please Login or Register  to view this content.

What about the message if there are blanks discovered? That is where I'm encountering the problem. Blanks = Message and stop macro, No blanks = call email macro.

This one sent the email even though there were blanks in the named range.

Let's say 1 = check for blanks 2 = call email macro.
if it finds blanks then it stops step one. If every cell is filled then go to step 2.

Workbook Attached - I need it to check cells B25 to B77 named range "Form_Task". If there are blanks then end the macro and show message to complete the checklist. If there are no blanks then call the email macro.Checklist - Sample.xlsb

Finally figured it out. Had to go with code below.

Please Login or Register  to view this content.