Send an email based on a cells value

shina67

Board Regular
Joined
Sep 18, 2014
Messages
64
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

Board Regular
Joined
Sep 18, 2014
Messages
64
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
 

Forum statistics

Threads
1,085,009
Messages
5,381,193
Members
401,718
Latest member
Ereese20

Some videos you may like

This Week's Hot Topics

Top