sending mail from Access without warning dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Balex - 03 Nov 2006 14:46 GMT

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

Reply to this Message

Armen Stein - 03 Nov 2006 17:10 GMT

> Hi,
>
[quoted text clipped - 12 lines]
> 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/)

Signature

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

Reply to this Message

Mr B - 03 Nov 2006 23:31 GMT

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

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

This should help.

Signature

HTH

Mr B

> Hi,
>
[quoted text clipped - 12 lines]
> regards
> balex

Reply to this Message