AutoRun Macro On Given Time/Date

[Legacy 185509]

Hi
I have macro I want it to run on given data & time please help me do that.
Basically it is Macro that would Run Automatically which will send me email automatically, I got all that working, only thing I need help with is to have this Macro once every week or now daily on given time for testing


Thank you

 

[VoG]

Take a look at the OnTime method http://www.ozgrid.com/Excel/run-macro-on-time.htm

 

[Legacy 185509]

I tired that code before posting it here, I also read somewhere using WorkSheet instead of Genera, that kind of worked but it wouldn't work the way I wanted it to, it would load it everytime I click anywhere excel sheet.

 

[Legacy 185509]

this is my code I m using
This codes ar in Sheet1 Objects

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'Application.OnTime TimeValue("08:52:00"), "Mail_Selection"

End Sub

it would run it automatically but it will keep on running more than once
how can I fix it
thank you

 

[Legacy 185509]

Bump