Another excel/email query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top