Using "DoCmd.SendObject" for automatic mailing

I use "DoCmd.SendObject ..." for automatic sending of mail.

It has however the disadvantage that for every mail, it
comes up a popup asking wether I want this mail to be sent or not, telling me that from somewhere in the
system there is some mysterious things going on.

How can I awoid this popup to occur?
Is there a setting somewhere?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


Set [Edit Message] parameter to false. This should keep the mail from opening for edit before it is sent, however if this popup is an error message there may be something else wrong. What message is being displayed?

    DoCmd.SendObject acSendNoObject, , , sendTo, , , sendSubject, sendMsgText, False

You could try using setwarnings.false which should turn off all warning messages

The only way to get round this is by using either ExpressClick Yes which sits in your system tray and waits for a Outlook Security bos and clicks yes on it for you. The problem with this is that if you get a virus that uses outlook to mail it will click yes for the security warnings.

That program can be found here

The other option is as stated in my previous post.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skybergAuthor Commented:
Wery good mr Jim Bob Joe.
Now I can call "ClickYes" directly from my program!
There is only one minus; how can I deactivate it?
Does the program (.exe) has a parameter.
By using no parameter, it is activated and one can see it in
the system tray, but how do I deactivate it from my program?

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.