View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PG Oriel PG Oriel is offline
external usenet poster
 
Posts: 37
Default Another excel/email query

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.