Automating Excel file creation and emailing created file

[vasah20]

hello -
is it possible to automate the creation of an Excel spreadsheet by creating a job, say once a week? I don't know much about jobs, but they seem like they only process T-SQL, please slap me if I'm wrong

If I can do this, I then need to know if I can email the file as an attachment to someone without using SQLMail? I looked through BOL trying to set up SQL Mail, and it seems like it needs a MAPI mail server to run. Our mail server is not MAPI compliant, so I thought that I hit a dead end. I *hope* that I'm wrong about SQLMail needing MAPI compliance...

We're using SQL Server 7.0, NT 4.0, IIS4.0, developing in an ASP environment.

any information regarding this would be greatly appreciated...
thanks -
leo

 

[tlbroadbent]

Create a DTS package with two steps.

Step 1 - Export from SQL to Excel.
Step 2 - Execute a program to send mail with the attachment. This can be your Email client or another program, whatever works.



Terry

http://members.home.net/tlbroadbent/index.htm