William Case <re**********@nospam.zap> wrote:
Does anyone have a line on some well written black box code that will
handle SMTP mailing sessions and can be integrated into a VBA app?
See the Access Email FAQ at my website. Particularly the third party controls
section.
Thanks Tony. I review the en tire site and found lots of great stuff.
Unfortunately, I did not see any SMTP products. Do you have a more
specific link?
Third Party Controls
Given that I have little control of my clients software and what other products they
have installed on them I like using controls which do the dialing (if required) and
the uploading/downloading of email directly.
I've had good success with the Mabry mail and RAS controls. Click here for my sample
code using the Mabry controls, DAO and a recordset to send the same email to many
email addresses. I did have to go looking in a non standard place
There are other controls available which Access programmers have indicated work in
Access.
SocketTools Visual Edition
H&S Technology, Inc
MarshallSoft Computing, Inc.
Codestone
The user configures Win 95/98/NT in the normal fashion for ISP connections. In the
Access software they enter their ID, password, mail server POP and SMTP name and ISP
phone number, choose the modem dialer profile previously defined to Win 95/98/NT, and
the Mabry controls do the dialing, uploading/downloading of email and your software
does the rest.
You aren't dependent in any way on how the system is configured. You don't have to
have all the various versions of Exchange and Outlook on your system to support the
clients. So long as they've configured Win 95/98/NT networking to connect to their
ISP. You control everything. You can also log, in your application, exactly when
email was received or sent.
As one programmer put it: "Users tend to tweak their profiles, so one day your
application works great, and the next day it crashes or sends out unreadable
attachments. Way too much tech support for me!"
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm