Help, Need to Email Querys

[Richard Albrecht]

Hi,

I need to automate a process that emails aproximatly 20 differant querys to
20 differant people. I want the query to go as an Excel spreadsheet. The
problem is:

I'm using DoCmd.SendObject.

Develpment Machine has Office 2000 with Outlook XP.
It works but the Message comes up saying "An application is trying to send
email, do you want to allow this?". This is a problem as it isn't automated
if someone has to press the button a hundred times. Any way to get rid of
that?

On Production Machine, straght Office / Outlook 2000 Access just shuts down.
This happens if the Edit Flag is true or False.

Is there some other way to automate this, perhaps a third party DLL???

TIA

Rich Albrecht

 

[Steve Schapel]

Rich,

What you are referring to is a security feature of Outlook. As far as I
know, this can not be disabled, although a post to an Outlook newsgroup
may get you a more authoritative opinion on this. I know that some
people have had success with overcoming this problem using a free
utility called ClickYes. See
http://www.express-soft.com/mailmate/clickyes.html