sending mail from Access without warning dialog box

[Balex]

Hi,

I have 2 Access apps that send mails using the Outlook object, works fine,
except one thing: everytime the mail is about to be sent by the app, a dialog
box related to Outlook appears warning me that my app wants to send a mail
and is that all right, etc.

How do I get rid of this dialog box ? I want my apps to work unattended,
they are scheduled tasks which might run when I have locked my PC and I'm not
around. Currently, the mails are not sent in such a case because I'm not
around to click the OK button of the dialog box... not good !

Any help much appreciated !

regards
balex

 

[Armen Stein]

Hi,

I have 2 Access apps that send mails using the Outlook object, works fine,
except one thing: everytime the mail is about to be sent by the app, a dialog
box related to Outlook appears warning me that my app wants to send a mail
and is that all right, etc.

How do I get rid of this dialog box ? I want my apps to work unattended,
they are scheduled tasks which might run when I have locked my PC and I'm not
around. Currently, the mails are not sent in such a case because I'm not
around to click the OK button of the dialog box... not good !

Any help much appreciated !

regards
balex

This is Outlook behavior, not Access. It's just trying to help you.

Some options:
- research code to send SMTP email directly from Access. Search Google
Groups for: vba smtp email
- look at Redemption for Outlook (http://www.dimastr.com/redemption/)

 

[Mr B]

Check out a special app that will click the Yes option for you:

http://www.snapfiles.com/get/clickyes.html

This should help.