How can I create weekly report with late tasks and tasks due this week of all team members?

Hello everyone,

I would like to create a weekly report that will be sent to Outlook e-mail and will contain: uncompleted/late tasks and tasks to be completed this week.

I need the report to have a structure like “My Work” (“past dates”, “this week”), but for each team member, i.e. the team member’s name, his/her “past dates” and “this week” items, under it another team member in the same structure, etc.

Is something like this even possible in Monday?

Thank you very much for your help!