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.

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


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



"PG Oriel" <(E-Mail Removed)> wrote in message news:A450DF8E-4C99-44D5-A194-(E-Mail Removed)...
> 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.