I do this for a few reports.

I use the rs.exe to generate pdf or excel files to a directory then use the sp_send_dbmail to sent to a list of email addresses pulled from an employee table. if you're sending the same file to the list of recipients then you can concatenate them together using an FOR XML PATH statement. otherwise you'll have to use a cursor or another loop structure.

I found this.[/url] It outlines how to use rs.exe.

I apologize for the terse answer. I haven;t looked at the code for this for awhile, so the exact details are fuzzy right now. I remember having to do a bit of futzing to get it to work but it was pretty straight forward. I can dig it out if you have questiois or run into problems.