Visual Basic coding to Auto submit MS Access Macro

[PJname]

I have a MS Access database where I have a macro using the "SendObject" Action where it sends several SnapShot report's to various individuals listed in the "TO" section. Unfortunately, I have to click on a button to send.

I don't want to include this in the AutoExec file on open since this database will be used by multiple users and these reports should only be sent at least once a day.

I want to be able to set this up where it will submit this macro at a certain time in the mornings.

Does anyone have Visual Basic coding to do this?

It should submit these reports regardless of whether the database is open or closed.

Thanks in Advance.......