Send object from Access through SMTP server

[LLBP]

I can email a query by scheduling a command in scheduled tasks that runs a macro to send object. The only stipulation is that I have to be logged in with Outlook open for it to work. I want to run the task on a server with SMTP installed without having to be logged in and be able to send the message from a certain email address. I have some VB code that will send a message throught the SMTP server but not an attachment. I'm using MS Access 2000 on Windows 2K. Can any one help?

Thanks,
Brent

 

[LLBP]

I found a solution (if you call it that): I had to use a scheduled task to open a macro, which runs a module, which exports the query results to a file and runs a batch file, the batch file runs a vb script that sends the query results to designated recipients.

THERE MUST BE A BETTER WAY!

The VB script would not run in Access and I couldn't run the VBS from Access.