WordPress.org

This plugin could also have been called Don't bother the Site Admin with every author's Moderation Messages but that's an even longer title. However, it explains well what this plugin does:

Normaly, when a comment gets posted to a particular post, the author of that post gets a notification about it. When that comment is held for moderation (which depends on your sites comment settings), the moderation notification is sent to both the post Author (if he/she has moderation rights) and the sites Administrative moderator e-mail address (as configured under Settings > General) at the same time.

For many blogs or sites where the owner is the only author and his/her account uses the same e-mail address as the Administrative moderator e-mail address, this will boil down to one message to one address. But when the Site Admin is not the only author, like on colaboration sites or sites managed by a webmaster or designer where other people like the client usually posts, this might result in overflooding the admins mailbox with moderation messages that are not really his/her concern. The site admin, with enough on his/her mind already, is bothered with each and every new comment in the moderation queue.

This plugin changes that.

Just install, activate it and it's done: All post comment moderation notifications will be sent only to each respective Post Author. If, by any chance, the post author has no moderation rights or there is no author e-mail set or the author is the site admin, the default site admin e-mail will still get the notification.

Works on WordPress 3.1 and above in both Normal and Multi-site mode.