I've been away from the forum for a while so I'm a bit late to reply. I essentially answered this same question a while ago in another thread. See this post as well as the two links referenced in it. It should provide you with everything that you need to write to a script that will do what you want.
Script for Subscriber notifications Let me know if helps or not.
