How to send a periodic report to all manager to check for their externals collaborators

In the PERSON table i have this information where the "lastname" column is the manager and their externals collaborators are in the "FirstName" column. So, for each single manager i want to send an email with an attachment (pdf or excel for example) where they can see all externals (in the "FirstName" column) that are headed to him, with some other information, for ex DepartmentName, ProjectCode, DefaultMailAddress and so on (i can decide with the customer). How can i do this? really many thanks