Send email from CLOSED Workbook.

[npacker]

Hi, all. I have two questions. First, is there a way that I can have excel send out an email that contains information from specific cells, at a CERTAIN TIME every day? Second question is can I have it do that even when the workbook is closed? I doubt I can have it send even if the workbook is closed, but I thought it couldn't hurt to ask.
Oh, and can I have it autofill-out the TO address with a prespecified address, and everything, so it doesn't have to open Outlook or anything, it just sends?

Thanks,
Nathan

 

[OdinsDream]

To do automatic scheduled tasks, try putting your workbook in the Windows' Task Scheduler. Then, add code to the workbook's On_Open event that does what you need, and automatically closes the workbook.

 

[Justinlabenne]

Look here:

http://www.rondebruin.nl/mail/folder1/mail4.htm

http://www.rondebruin.nl/mail/folder3/message.htm


and for the automating it even more, download this:

http://www.contextmagic.com/express-clickyes/

 

[npacker]

Thanks, that's actually a good idea. However, this file is going to be stored on a company file server, and I'm not sure it's running Windows. It may be running Linux or something. I'll have to find out and see. Thanks for the reply!
Nate

 

[OdinsDream]

As long as the PC you're opening it with has Windows, you can open it with Task Scheduler. The OS of your fileserver doesn't matter.

If you're opening this file in a Linux PC using some kind of emulation to open excel documents, that's a different matter. I'm sure you could use cron to schedule the opening of the document, though.

 

[npacker]

Thanks for all the great ideas. However I just found out that our system admins won't allow any sort of scheduling on the server anyway. And having it scheduled on one of the windows boxes won't work, because none of our windows boxes are always running. We work in shifts with "hot-seats" where everyone has a removable hard drive, and their not always here. Anyway, we're just going to have to have the shift lead email it out everyday or something. Damned if they have to do some actual work!
Thanks anyway,
Nate