Automatically Send an Email with CDO at Specfic Date and Time

Hello,

I got the code below from www.rondebruin.nl and it works great for sending an email to my gmail account (I've altered it slightly). Can someone show me what code I would need to add in order to set this up for a future date and time? Lets say, 9:00AM (EST) on 11/27/2011. And is it possible to automatically execute the macro without having Excel open or having my computer on as long as I had an internet connection that is always connected?

Thank you!

Please Login or Register  to view this content.

Thanks to the person who adjusted the title to make it more accurate.
Anyone have any ideas?

Hi Leith,

Thanks for your response. I am looking into both of your answers. I will get right back once I read a little on both.

Okay, I've decided to go with the "Scheduled Task" option first and am encountering this error:

The new task has been created, but may not run because the account information could not be set.

The specific error is:

0x80070005: Access is denied

Try using the Task page Browse button to locate the application.

I have browsed to the correct path of the file. Do I need to save the Excel sheet with a different extension other than .xlsm ?

I thought it might be password related cause I didn't have an administrator password. I've created one and am still encountering the same error.

Leith,

I'm still getting the error below, any thoughts as to why?

An error occurred while attempting to set account information.

The specific error is:

0x80070005: Access is denied.

You do not have permission to perform the requested operation.

When it asks for a password, is this password something that was previously created, or
is it asking me to create a new password to allow the task to run?

Leith,

I've got the "Scheduled Task" to work and it opens the file fine. I have authorized the file to open without having to manually confirm the macro as well. However, the macro is not running. At this point, I'm assuming that I am missing something from the code that I posted earlier that automatically starts the macro. Could you show me what I need to add?
Thanks a lot for your help!

Leith,

Thanks. I was messing around with this last night and got it to work by pasting the code right in "ThisWorkbook" (I altered it a little bit), then I just removed the module. This is the code that I used. Thanks for all your help.

Please Login or Register  to view this content.

Leith,

I'm having trouble marking the thread as "solved". I've got to leave my office right now, but I'll figure it out when I get back in!