Automatic E-mail Containing Excel Document

[RossWindows]

I have an excel document that contains a query.
It pulls records from my database.

I am trying to think of a way that I can have this document automatically sent to our other call center which is out of state.
They don't have access to our network, so this is the best solution I have come up with so far.

I know I can make a scheduled task, but the problem with that is that I am out of the office 2-3 days a week.
They need the document e-mailed to them every day.

Any ideas?

 

[Fuga]

You can automate msOutlook to send emails with attachments.

If you need to do this every 24 hours or so you can use a form´s timer event.

To export a query to excel format you can use TransferText.

Are you familiar with vba programming?

Fuga

 

[pbaldy]

Can you leave your computer on so that the scheduled task will continue to run when you're out?

 

[Minkey]

Your best solution would be to move all the relevant stuff onto a server (or another machine) that can be left on 24/7.

 

[RossWindows]

The excel file is located on a shared drive on the server.
Fuga, are you saying I can program outlook to grab a particular attachment and e-mail it every 24 hours?