Automate SQL Server reports and send them by mail

I work in a large retail business with a decent SQL Server environment. We have SQL Server replication, Availability Groups, Data warehouse, and some cloud services. In this beautiful environment, we use desktop applications with limited features. The business always needs some extra reports that the application support team delivers them late most of the time. As a senior DB Admin, they come back to me to try extracting the data form SQL Server to Excel files. As we grow larger and larger it has become almost like a daily task, I’ve managed to develop a C# tool to send most of those reports by mail to every one who needs them, but now it has become outdated and to be honest it takes a lot of time to be rewritten. Is there a tool that can run SQL query and add the results to Excel file and mail it to specific emails list ?