Email if cell states "Yes"

[CFSpedian]

Hi, Im trying to create a formula that all cells within column M on sheet 3 contains. Once the word "Yes" is inputted an email is sent to a specific person.

Thanks in advance.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.


To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[CFSpedian]

It states I have uploaded but not sure.

Thanks