Executing a macro at a defined time

[celtic warrior]

I have a worksheet that is used to update daily events. I currently have a macro which is operated manually to send a copy of the worksheet to a defined mailing list.
I would like to automate this process so that the worksheet is mailed at a defined time each day.
I tried the following:

Please Login or Register  to view this content.

But it doesn't seem to work?

CW

[Leith Ross]

Hello Celtic Warrior,

If you are using a VBA macro to send the email using Outlook from Excel, you can to do this way...

Please Login or Register  to view this content.