Speedboxer

The Comment Approval Notification plugin will send an email to the comment author when you approve their comment. The email sent is fully customizable, with shortcodes, through a settings page.
Please note that this plugin has only been tested with PHP 5.2.x.
A full list of available shortcodes is available <a href="http://mattsblog.ca/plugins/comment-approval-notification/#shortcodes" title="Available Shortcodes" rel="nofollow ugc">here</a>.

Comment Approval Notification

Sends an email to the comment author when their comment gets approved (only if it's held for moderation).

Rahul Mukherjee

Currently WordPress only sends an email to the email address entered in the Options->General->E-mail address field when any new comment is submitted or that comment is awaiting moderation (depending on what you have selected for the comment moderation options in your installation).
For those of us who need more than one email address to be notified, no solution existed. Until now. Comments Notifier was developed to address this problem.
Uses:
<ul>
<li>If you have more than one person modding your site , they can now receive emails alerting them that new comments are awaiting moderation.</li>
<li>Send general comment notifications to yourself at multiple email addresses and also if any new post or page is created or updated then </li>
<li>the email will also work.</li>
</ul>
<h3>Use and Configuration</h3>
Simply enter the email addresses one at a time into the plugin. Validly formatted email addresses are required. You may not add the same address twice. There is no limit on the number of email addresses you can enter, though for the sake of performance, I would recommend that no more than 20 be entered.
In the “Post Comment Notification To Multiple User” section you can configure the plugin to send emails only for comments that require notification, as opposed to all comments.
If you wish to remove an email address, simply click on the “Remove” button beneath the corresponding email address in the “Current Notification List” section of the admin.