Send an email based on a cells value

[shina67]

Hi All,

I have a worksheet that when a cell in column F is changed I want to email out a message to a particular person.
I.E. if the cell in F is changed to Production I want to email Chris Smith with a message letting him know that he has a new Non Conformance that needs actioning.
If the cell in F is changed to Survey I want to email Lee Ashton with the same message etc etc.

I am reasonably new to VBA and not sure on the coding that is required to do this.

 

[shina67]

Hi All,

I have a worksheet that when a cell in column F is changed I want to email out a message to a particular person.
I.E. if the cell in F is changed to Production I want to email Chris Smith with a message letting him know that he has a new Non Conformance that needs actioning.
If the cell in F is changed to Survey I want to email Lee Ashton with the same message etc etc.

I am reasonably new to VBA and not sure on the coding that is required to do this.

Bump

 

[Macropod]

Cross-posted (and responded to) at: https://www.excelforum.com/excel-pr...197-send-an-email-based-on-a-cells-value.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html