Look here
http://www.rondebruin.nl/mail/folder3/message.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"PG Oriel" wrote in message ...
Hi...

Column B has teachers email in. Column C has pupil's name in. Column D has
detention date in. Column E has whether the detention has been completed and
has a drop down box in, defaulted to No.

Is it possible that when the drop down box changes to a Yes, that an email
is sent to the teacher on that row, along with the name and date of it,
stating it is completed???

Thanks.