I'm sorry if a repeat a question that already been asked in this forum, but i could not find the answer to my question. I have reports that i want acces to email each morning automatically. I have created a sendobject macro. When the marco is run i get the following prompt "A program is trying to automatically send e-mail on your behlf".... Is there a way to turn this off?

2 ways offhand. One is a utility I've used called ClickYes, the other is called Outlook Redemption. Searching should turn up more info on both.

pbaldy,
Thanks for the suggestion were can you find the items you suggested. I have never heard of them

I have never heard of them

Google has.

The company i work will not allow us to download programs off the internet. Is there coding i could in access that will allow emails to be sent?

If there are no exceptions, then they're a bit shortsighted, but here's some more info:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;263084

Thanks i'll look into what you gave.