Sending An Automated Report Via EMail

[Guest]

I am currently trying to send a report via access and email every hour. At
the moment I have set up a macro to send the report and this works find
however it comes up with a dialoge box to say that "A program is sending an
email, if you havn't requested this say no etc etc." The problem is that this
means that the database remains open until you acknowledge this which isnt
suitable as I want to just leave it to get on with the job.

Is there a way to disable this alert. At the moment My macro only includes
the following lines:

SendObject
Quit

Any help would be greatly appreciated.

Thanks

Brian
brian.thomson(remove this)@ntlworld.com

 

[Guest]

Brian, I assume you are using Outlook ?? This is a known issue and can be
'fixed' using this free program
http://www.contextmagic.com/express-clickyes/ . I use Groupwise and luckily
have never had to work with this problem.