Warning when sending email through vba, OL2000

[ChrisCalvert]

I have a database that uses VBA to send emails to a list created by a query. On my PC this works fine, but on another PC this causes a warning (A program is trying to send an email...). I seem to remember this warning before, but on my PC I did something to make away with it. Here's the question: What did I do? Or what can I do? I need this to send several hundred emails a day, I can't have this warning before each one. Anyone know what setting (In Outlook 2000 SR1, Access 2000, or Windows 2000) will stop this warning? John, I've been bad
and they're coming after me.
Done someone Wrong,
and I fear that it was me. -TMBG

 

[LLudden]

If you are using exchange server, you can create a security profile that allows the sending of messages with VBA unprompted.