Ramprasad Sundaram
New Member
- Joined
- Sep 19, 2019
- Messages
- 1
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
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