Send email from CLOSED Workbook.

npacker

Board Regular
Joined
Oct 14, 2004
Messages
132
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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

OdinsDream

Well-known Member
Joined
May 19, 2002
Messages
541
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.
 

npacker

Board Regular
Joined
Oct 14, 2004
Messages
132
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

Well-known Member
Joined
May 19, 2002
Messages
541
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

Board Regular
Joined
Oct 14, 2004
Messages
132
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
 

Forum statistics

Threads
1,147,621
Messages
5,742,180
Members
423,709
Latest member
AMacL

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top