Automating Report Emails

I have my MDB data stored on SQL server. I am wondering the what would be the
best method to have reports automatically run every morning at 6:00 AM and
then email these reports to a distribution list.

Do I use the windows scheduler to open a database that runs an autoexec
macro that will run the reports, saving them to a file and then attach them
to an email and send out? Can I attach more than one file to an automated
email? Can I attach a .pdf file to the email? I would like to print a set of
reports to a set of pdf files and email them as a bunch to a group of senior
management.

Is SQL server a better too to use? Can I ust DTS in SQL Server to open an
access database and print reports to a file and then email them?

If you have any suggestions on the best methof I would appreciate any advise.

Thanks


--
Jay