I'd sure NOT put anything in a trigger that has to do with actual emailing or any other form of RBAR unless you like getting phone calls about why the server is so slow. The most I'd do is have it fill another table with the information in a set based fashion and let a separate email "crawler" proc handle sending the emails.

If you don't think so, consider what happens if the email server goes down. 😉