Workflow Workbench

here is a reference:
https://drupal.org/project/workflow_extensions
This has detailed instructions on how to set up workflow rules, example is a notice sent via email.

here is the basic module
http://ftp.drupal.org/files/projects/workflow-7.x-1.1.zip

and the extension:
http://ftp.drupal.org/files/projects/workflow_extensions-7.x-1.0-beta4.zip

tutorial here:

http://blip.tv/gotdrupal/drupal-workflows-automation-1959504