Is there a way to make the comment module email the administrators when a comment needs approval? I'd like to be notified whenever comments are made on the site which require administrator approval before publishing; basically, I'd like to know when something new appears in the Approval Queue. I can't see any obvious settings for this.
Sounds like something Rules should be able to do.