I want to Use a Utility to Send Daily Defect List in Email in RTC
One answer
Honestly, I think this is not a good use of your time and would rather suggest to use a dashboard to convey this information like any one else does.
However, you could look if https://jazz.net/forum/questions/220776/can-i-programmatically-export-a-report-builder-report/222085 helps.
Alternatively it would be possible to use the work item command line https://rsjazz.wordpress.com/2019/07/03/work-item-command-line-5-0/ to run a query and to export the query result as CSV. You could process the CSV and compose an e-mail from the data.