>>I need to produce an Excel report or PDF report every night (Schedule SQL Job) and email it to some users.
>>How can I do that?
>
>There are a number of ways to do it. The one I like is Blat. It's straightforward to use and doesn't have a lot of Windows dependencies as some other solutions do. You call it with the expected parameters -- from address, to address, message title, message body, some optional stuff -- and it does the rest.

Yes - BLAT.DLL works great and does not require any other email client or program to work.

Look at XFRX (Sergei mentioned that in the other thread on this) for generating a report as PDF - simple and solid.