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? :confused:

Thank you for your help.

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