Consolidated school email report

Our organization would really benefit from a report that would pull the Director email associated to each school. We use RPAs multiple times a week to pull Procare reports and need an easy way for the Bot to generate an accurate current email list for the main contact at each school to send these reports. A similar report exists from the "Regions and Schools" configuration section, which will show the school name alongside the Director's name. We just need a column for the email associated with that school.