Excel code to trigger mail

[Ramprasad Sundaram]

I've a monthly data base register with 50 plus members. I find few members are not entering data in specific cells or entering data which is out of date (EX: Actual end date is exceeding present date). I need to send mail every time to all defaulters. Please find my requirement below and anyone kindly help me out creating Excel Macro code to create a single tap button to filter all unfilled and over dated entries and send mails which will be available in respective next cell.

Step 1: Need to filter the cells which was not entered or kept empty
Step 2: Trigger mail to all filtered mail ids in the respective next column cells.

Thank you in advance

 

[Logit]

.
Keep in mind that you know what you are looking at. We don't.

You would need to provide the present layout of your workbook. The best method is to post a copy of your workbook to a cloud site (like DropBox.com or similar)
then post the link for download here.

Be certain to not leave any confidential information in the workbook.