I have set up a markbook that automatically gives a student a grade by using
a lookup table for grade boundaries. We have a reward system where pupils
are given a merit for 3 'A' grades. Is it possible to get Excel to know when
this has been met and select those pupils for a mail merge. I can do this
manually but if I could automate it it would be fantastic and a great
time-saver.

Many thanks