you can use the procedure to first have the list of students

absent in a particular department and then use the procedure

sp_send_dbmail to send the list of absentees in the mail.