Intermittent Problem Sending Email from Access

[Michael Nagan]

I'm having a problem sending email from an Access application. It seems to
work for a while and then stops working for reasons unclear to me. Here are
the details:



The Access 2000 application runs continually and unattended on a machine
running Windows 2000 Server. The server is doing little more than run this
application. Periodically it queries another database on the network and
sends out emails based on the result of that query using the following code:



DoCmd.SendObject , , acFormatTXT, strEmailAddress, , , strSubject, strBody,
False



The emails are sent out via Outlook Express 6.



It works fine for an hour or a day or two, and then stops sending emails.
The application continues to run (it continues to send out net messages just
fine) but no more emails. I've tried it with Outlook Express open and
closed, with the same results. I'm not sure if the problem is with Access,
Outlook Express, or where.



I'd appreciate any suggestions you may have.



Thanks,



Michael Nagan

(e-mail address removed)

 

[Rick Brandt]

I'm having a problem sending email from an Access application. It
seems to work for a while and then stops working for reasons unclear
to me. Here are the details:

Access 2000 introduced a lot of problems with SendObject. I assume later
service patches and/or versions 2002 or 2003 resolved these but I don't know
for sure. "Silent" failures to send messages without throwing an error was
one of the problems cited. The original article I saw on Microsoft's site
had a fix that amounted to "don't use SendObject".

A pretty easy way to send Emails without using SendObject on a Windows 2000
box is to automate the CDOSys library.