automated emails

I am trying to set up automated emails with specific criteria. We are an engineering firm that uses Quickbase to track projects and workflow. i would like to send a weekly email to the employees that would show how many of their projects were approved, rejected, how they compare to their peers, etc... I know that there is capability within Quickbase to set up emails but I am not sure if you can (and how to) create specific criteria or if you can only use one of the existing formats that are currently in Quickbase.