Send Email in VBA without security dialog box

[Guest]

I have an Access application that copies files from one server to another. Upon completion of the transfer, the program sends a confirmation email. When the program tries to send the email a warning message appears saying that a program is trying to send mail on your behalf and asks if you want to allow the message to be sent

As this program is scheduled to run at night (when the computer is unattended), I need to turn off these warning messages. I have read the Microsoft Knowledge Base article 290500- Developer Information About E-Mail Security Features. As per one of the solutions suggested in the article, I installed the Access application on a server, but the messages still appear. The article also recommends using "the administrator features to disable object model restrictions...". Anyone know what this means

Thanks in advance

 

[Andy]

Hi Rob,

I get this message whenever I open a mail message from Outlook 2000. I am
not sure there is a way to bypass this from Access.

However, you might consider using a 3rd party smtp e-mailer, such as Blat,
to circumvent the problem.



Hth,

Andy

I have an Access application that copies files from one server to another.

Upon completion of the transfer, the program sends a confirmation email.
When the program tries to send the email a warning message appears saying
that a program is trying to send mail on your behalf and asks if you want to
allow the message to be sent.

As this program is scheduled to run at night (when the computer is

unattended), I need to turn off these warning messages. I have read the
Microsoft Knowledge Base article 290500- Developer Information About E-Mail
Security Features. As per one of the solutions suggested in the article, I
installed the Access application on a server, but the messages still appear.
The article also recommends using "the administrator features to disable
object model restrictions...". Anyone know what this means?

 

[Cheryl Fischer]

Rob,

I believe the article which refers to "administrator features" applies only
to those using Outlook in an Exchange environment. Outlook users operating
outside of the Exchange environment cannot turn this prompt off. There are
a few options available, as outlined by Outlook MVP Sue Mosher:

If you're the administrator in an Exchange Server environment, you can
reduce the impact of the security prompts with administrative tools. See
http://www.slipstick.com/outlook/esecup/admin.htm

If it's an application you wrote yourself, you can use one of these
approaches to redo the program:

-- Use Extended MAPI (see http://www.slipstick.com/dev/mapi.htm) and C++
or Delphi; this is the most secure method and the only one that Microsoft
recommendeds.

-- Use Redemption (http://www.dimastr.com/redemption/), a third-party
COM library that wraps around Extended MAPI but parallels the Outlook Object
Model

-- Use SendKeys to "click" the buttons on the security dialogs that your
application may trigger. See
http://www.slipstick.com/outlook/esecup.htm#autosec for a link to sample
code.

-- Program the free Express ClickYes
(http://www.express-soft.com/mailmate/clickyes.html) tool to start suspended
and turn it on only when your program needs to have the buttons clicked
automatically."

I have used the ClickYes utility successfully for myself and for a client,
using code provided by ClickYes which turns the utility on just before
sending the emails and turns it off when the process has completed. It
does not get rid of the prompt, but it uses code to click the 'Yes' button
for you.

hth,


--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I have an Access application that copies files from one server to another.

Upon completion of the transfer, the program sends a confirmation email.
When the program tries to send the email a warning message appears saying
that a program is trying to send mail on your behalf and asks if you want to
allow the message to be sent.

As this program is scheduled to run at night (when the computer is

unattended), I need to turn off these warning messages. I have read the
Microsoft Knowledge Base article 290500- Developer Information About E-Mail
Security Features. As per one of the solutions suggested in the article, I
installed the Access application on a server, but the messages still appear.
The article also recommends using "the administrator features to disable
object model restrictions...". Anyone know what this means?