Sounds like you could use a subscription to do this. That will handle sending the reports to each user. If you're not using Enterprise, you can use Jason Selburg's code to mimic that in a non-enterprise version of SQL Server. You have to have Agent though.