I hate doing this in individual emails, since I think it's a poor design practice. Over time, or when things are busy, people get tons of emails that aren't necessary. This isn't really real-time information.

I'd use OUTPUT or a trigger and insert the values into a logging table. Then I'd send emails every 10, 20, 30 minutes, reading the logging table, looking for changes and emailing people with the changes.