By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

SMTP code for VBA?

P: n/a
Hi Folks,

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?

Thanks.
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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.

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
Nov 12 '05 #2

P: n/a

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?

On Sat, 04 Oct 2003 17:56:05 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
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.

Tony


Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
On Sun, 05 Oct 2003 23:47:12 GMT, Chuck Grimsby
<c.*******@worldnet.att.net.invalid> wrote:

How "Black Box" do you want to go?

I've posted code to do SMTP via the winSock control previously in this
newsgroup. Search for it at Google if you want.

Do you *need* to go lower then that? Down to the DLLs? Why?

(I did it for fun once, but so far I haven't come across a case where
I had to use it. The WinSock.OCX fills all the needs I've had so far,
so I'm curious in what conditions you would have that would require
going to the DLLs.)
Perhaps I was a bit sloppy in my use of the term "black box". I would
prefer to get a code module with properties and methods I can call in
my code to perform various SMTP functions, like sending to one,
sending one message to many, logging what was sent, etc. THAT is what
I mean by "black box" -- a little "magic" black box where stuff goes
in, stuff comes out, but I don't have to worry about what happens
inside the box. If that be a DLL, then so be it. Is that expecting
too much?

On Sun, 05 Oct 2003 17:27:39 -0500, William Case
<re**********@nospam.zap> wrote:
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?

On Sat, 04 Oct 2003 17:56:05 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
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.


Nov 12 '05 #5

P: n/a
Chuck Grimsby <c.*******@worldnet.att.net.invalid> wrote:
I've posted code to do SMTP via the winSock control previously in this
newsgroup. Search for it at Google if you want.


I forgot to mention that section on my FAQ. A link to your posting is in the
"Directly via the Winsock" section of my website as well.

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
Nov 12 '05 #6

P: n/a
On Mon, 06 Oct 2003 22:47:07 GMT, Tony Toews <tt****@telusplanet.net>
wrote:
Chuck Grimsby <c.*******@worldnet.att.net.invalid> wrote:
I've posted code to do SMTP via the winSock control previously in this
newsgroup. Search for it at Google if you want.


I forgot to mention that section on my FAQ. A link to your posting is in the
"Directly via the Winsock" section of my website as well.

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


Tony, I cannot find ANY text on your site labeled "Directly via the
Winsock". Help!

Nov 12 '05 #7

P: n/a
LaurenW <re**********@nospam.zap> wrote:
Tony, I cannot find ANY text on your site labeled "Directly via the
Winsock". Help!


About 2/3s of the way down on http://www.granite.ab.ca/access/email.htm

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
Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.