Can a register automate a memo for none attendance?

I use excel as register to tally attendance in lectures and tutorials. We
have been requested to send an e-mail to a personnel tutor of students if the
student fails in attending two consecutive sessions. We enter attendance as
either a 1 or a 0 in a horizontal row. I want to automate a response so any
students name is generated who gets two consecutive 0’s. I could then cut and
paste this into an email. I would like this not to interfere with a formula
to give a final attendance total and the end of the row.
I use Microsoft EXcell 2002-SP-2
Please can anyone help? I may have some time to get down to more important
things such as teaching if I can remove this type of time consuming task.

Crumm,

This is easy enough but it needs VBA.

If you have all the tutor emails linked, you can automate the mailing too.

If you mail me a sample workbook, I can do it for you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Crumm" <[email protected]> wrote in message
news:[email protected]...
> I use excel as register to tally attendance in lectures and tutorials. We
> have been requested to send an e-mail to a personnel tutor of students if
the
> student fails in attending two consecutive sessions. We enter attendance
as
> either a 1 or a 0 in a horizontal row. I want to automate a response so
any
> students name is generated who gets two consecutive 0's. I could then cut
and
> paste this into an email. I would like this not to interfere with a
formula
> to give a final attendance total and the end of the row.
> I use Microsoft EXcell 2002-SP-2
> Please can anyone help? I may have some time to get down to more important
> things such as teaching if I can remove this type of time consuming task.
>