VBA code to ensure mandatory fields are filled in before send email??? Many thanks!!!!

Below is my workbook attached.

I would like the user to fill in the mandatory fields before selecting the Send button on sheet.

If mandatory fields are not filled in on sheet a MsgBox will appear.


So far I have only managed to code the send email button and if data is not entered in cell I7, i would like to please have help on how to code to ensure that other mandatory fields are filled.

Below i have attached my workbook.

Many thanks!!!


Kind regards,

Kamal Rajput

I do my checks via code (not in the field property)
Easier to change...

usage:
if IsValidForm() then SendEmails()

Please Login or Register  to view this content.