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
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