Well, you can write an application which runs a query (utilizing OSLC/REST API or Java API), processes the XML response, and then sends emails through an SMTP server.
I don't think RTC itself has such feature as it is not part of the "notification".
Ralph Schoon selected this answer as the correct answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means.
Learn more here.