SendObject Macro - automation

[dirtchamber]

Hi all. I have a sendobject macro that send an email to a certain address, with a report attached, when I click a button. Is there a way to make this macro automated? Like, if I want this mail to be sent every Friday at 18:00, without user being able to stop it?

Thank you for your help.

 

[freakazeud]

Hi,
you could create another macro which calls your macro and then call that macro with the windows scheduler or you can call your original macro directly with the windows scheduler: http://support.microsoft.com/?kbid=230575
This way you can basically automate the whole process without needing to open access manually!
HTH
Good luck