Macro to send emails from excel using filters

Hi All

I am looking for a macro where it send emails automatically from my excel using the following filters

 Send emails to the Contact name wherever

- Completion DT is blank ,
- Vendor tier Risk level is not Low
- Submit date is not Blank,
- Comments are blank
- Duplicate is blank

sample test - macro to send emails with multiple filters.xlsx

I have highlight the columns (blue color) where email needs to be sent from excel basing on the above filters

 Should send mails from kiran_kurapati777@yahoo.com
 update with the Date in th the mail Sent Date column as soon as mail is sent.
 Post which automatically Save the file “Training_Followup_Done_Date” on desktop
 Once the file is save…. A Message box should pop up saying “Task Completed”
 After the 7 days of running a macro a reminder mail should be sent to kiran_kurapati777@yahoo.com Saying “Kindly check for updates in the Training follow up project”
Thank you for all your support

Regards
Kiran Kumar

Here we go.... got a solution

Please Login or Register  to view this content.