Oh yes, this one is vital, and the thinking behind the steps involved can be applied to achieve other vital functionality…

http://thewichitacomputerguy.com/blog/email-drupal-comments-approval-admin-email-address