There are several out of the box reports which can be scheduled to run and can be distributed to the appropriate audience. The reports are named Request Detail Report, Request Summary Report and Request Quick View Report. By using the scheduling functionality located at the bottom of the report setup screen, you should be able to get the desired information.
Hi, for most reports you need to set the start and end date of that week for each week. The only reports that allow past periods (e.g. 1 week) are the Demand reports. Your request type needs to be part of a demand set for these reports.