You can automate queries in PPS to automatically email the query on chosen days at given times. This will email a CSV file of the query results.
Choose the Query you wish to automate
Choose Automate and then click Save
Next click the folder Icon
Select the days you want to report to run and the hour you want it to run on those days. Then enter the emails with a ";" in between to send to multiple recipients. Then click Save