Macro To Email Object

[BruceJackson]

I have created a Macro to email a report and included it in Autoexec macro - can the message box where you allow the email to go ahead be disposed of?

Ideally, I would like to enable the Access DBS to automatically email at a set time 5 days a week without the need to open the database.

Any ideas?

 

[M8KWR]

you could try to include SetWarnings = No - this turns off all system messages.

You best putting this first...

Hope this helps.