need assistance in send mail macro
Hi guys,
Please find attached sheet. If we click on validate button it highlights all cells in mandatory columns which are blank and pops up a message on the screen stationg "Please fill up mandatory fields.
My question is if there are no blanks in the mandatory columns. then macro should not pop up that message it should draft an email.
i have designed the code but its either highlighting blanks cells or drafting email. am not bale to combine both the things.
kindly assist.
|