PC Review


Reply
Thread Tools Rate Thread

Send Email in VBA without security dialog box

 
 
=?Utf-8?B?Um9iLUxNUw==?=
Guest
Posts: n/a
 
      16th Apr 2004
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
 
Reply With Quote
 
 
 
 
Andy
Guest
Posts: n/a
 
      16th Apr 2004
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

"Rob-LMS" <(E-Mail Removed)> wrote in message
news:0EF88F4E-FAFF-4809-945D-(E-Mail Removed)...
> 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



 
Reply With Quote
 
Cheryl Fischer
Guest
Posts: n/a
 
      16th Apr 2004
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


"Rob-LMS" <(E-Mail Removed)> wrote in message
news:0EF88F4E-FAFF-4809-945D-(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
send pictures via email dialog box Chris Windows XP Photos 4 7th Jul 2007 04:50 AM
how do i send an email from the dialog box =?Utf-8?B?amltbWk=?= Microsoft Outlook Discussion 1 3rd Nov 2004 09:07 AM
Send Email in VBA without security dialog box =?Utf-8?B?Um9iLUxNUw==?= Microsoft Outlook VBA Programming 0 16th Apr 2004 06:21 PM
Re: Send Email in VBA without warning dialog box Sue Mosher [MVP-Outlook] Microsoft Outlook VBA Programming 0 16th Apr 2004 06:06 PM
Send Pictures Via Email Dialog Box yvonne Windows XP Photos 2 5th Oct 2003 09:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:07 PM.