Sending e-mail from Access

  • Thread starter Thread starter Steven M. Britton
  • Start date Start date
S

Steven M. Britton

I am using a command in Access to send an e-mails
automatically. But each time an e-mail goes out I get the
new virus warning (which is a good idea) that asks me if I
want to allow this.... I need to have this shut down
during this mailing process because it is slowing down the
e-mailing.

What I do is send an invoice out of Access to a fax number
in to line that goes over MSFax, I send them when I go
home at night to past due customers. But now with XP I am
not getting them all out at night because it runs so
slow. Please help.

-Steve
 
The most complete information regarding dealing with the Outlook Security
Prompt has been provided by Outlook MVP Sue Mosher and is as follows:

BEGIN QUOTED MATERIAL:

"The security dialogs that pop up when an application tries to access
certain Outlook properties and methods are designed to inhibit the spread of
viruses via Outlook; see
http://www.slipstick.com/outlook/esecup.htm#autosec. If you are a standalone
user, Outlook provides no way to suppress this behavior. However, you can
use a free tool called Express ClickYes
(http://www.express-soft.com/mailmate/clickyes.html) to click the security
dialog buttons automatically. Beware that this means if a virus tries to
send mail using Outlook or gain access to your address book, it will
succeed.

"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."

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

END OF QUOTED MATERIAL
 
A programmer friend of mine actually gave me a very simple procedure to use
which avoids all the security problems that might exist at your institution
for Exchange. This procedure address Exchange at a lower level; if you're
using Exchange, try this (it worked for me beautifully):

*** beginning of code ***

Dim l_Message As CDO.Message
Dim l_Configuration As CDO.Configuration

Set l_Configuration = New CDO.Configuration

With l_Configuration.Fields
.Item(cdoSendUsingMethod) = cdoSendUsingPort
.Item(cdoSMTPServer) = "PUT_YOUR_EXCHANGE_SERVER_NAME_HERE"
.Update
End With

Set l_Message = New CDO.Message

With l_Message
Set .Configuration = l_Configuration

.To = "(e-mail address removed), (e-mail address removed)"
.CC = "(e-mail address removed), (e-mail address removed)"
.BCC = "(e-mail address removed), (e-mail address removed)"

.Subject = "Subject"

.TextBody = "Body"

.From = "(e-mail address removed)"
.Sender = "(e-mail address removed)"

.AddAttachment "c:\folder\filename1"
.AddAttachment "c:\folder\filename2"

.Send

End With

Set l_Message = Nothing
Set l_Configuration = Nothing

*** end of code
 
Back
Top