Send an automatic email alert when cell value is "Yes"

[euan2711]

Hi,

I hope somebody here can help. I have been looking on many forums and websites for a solution to this problem but have yet to crack it!

Firstly let me just say that I am a complete novice when it comes to coding so please bear with me.

Basically I have a spreadsheet to monitor behaviour in a high school. There is a column in the sheet with the heading 'PT Action Required?' which has a drop down menu where users can either select "Yes" or "No".

I would like the spreadsheet to automatically send me an email to inform me if a user selects "Yes".

So far I have:

Please Login or Register  to view this content.

However, nothing happens.

Does anyone have any ideas?

Thanks in advance

[Charles]

Hi,

See if it works when you have "Outlook" open.

[kiboodez]

Hi Eaun,

I am looking for exactly the same thing for exactly the same reason! If you manage to get it working then please let me know!