• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How To Automatically Send Email Based On Cell Value In Excel?

prasana05

New Member
Hi Team,

Please find attached the excel file. This file will be used for Attrition calculation for my teams.

I need help with Excel to send an automatic email using outlook when a cell value is changed in the file.

Question . Sheet name "Attrition Report" Column L in the file has the list of RAG status, So a manager will choose one of the options (Green, Red, Amber) for possible attrition cases. When the cell value changes to Red or Amber ; excel should automatically send an email. The body of the email should show employee name which is in Cell range "B" and the RAG status which is in Range "L".
I put the code but i guess it's incorrect.

Any help on this will be much appreciated.

Thanks and Regards

Emanuel Prasanna Kumar
 

Attachments

  • Attrition Report.xlsx
    15 KB · Views: 10
Back
Top