SMTP code for VBA?

[William Case]

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.

[Tony Toews]

Re: SMTP code for VBA?

William Case <replytogroup@n ospam.zap> wrote:
[color=blue]
>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?[/color]

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

[William Case]

Re: SMTP code for VBA?


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 <ttoews@teluspl anet.net>
wrote:
[color=blue]
>William Case <replytogroup@n ospam.zap> wrote:
>[color=green]
>>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?[/color]
>
>See the Access Email FAQ at my website. Particularly the third party controls
>section.
>
>Tony[/color]

[Tony Toews]

Re: SMTP code for VBA?

William Case <replytogroup@n ospam.zap> wrote:
[color=blue][color=green][color=darkred]
>>>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?[/color]
>>
>>See the Access Email FAQ at my website. Particularly the third party controls
>>section.[/color][/color]
[color=blue]
>Thanks Tony. I review the en tire site and found lots of great stuff.
>Unfortunatel y, I did not see any SMTP products. Do you have a more
>specific link?[/color]

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

[William Case]

Re: SMTP code for VBA?

On Sun, 05 Oct 2003 23:47:12 GMT, Chuck Grimsby
<c.grimsby@worl dnet.att.net.in valid> wrote:
[color=blue]
>
>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.)[/color]

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?

[color=blue]
>On Sun, 05 Oct 2003 17:27:39 -0500, William Case
><replytogroup@ nospam.zap> wrote:[color=green]
>>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?[/color]
>[color=green]
>>On Sat, 04 Oct 2003 17:56:05 GMT, Tony Toews <ttoews@teluspl anet.net>
>>wrote:[color=darkred]
>>>William Case <replytogroup@n ospam.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?[/color][/color]
>[color=green][color=darkred]
>>>See the Access Email FAQ at my website. Particularly the third party controls
>>>section.[/color][/color][/color]

[Tony Toews]

Re: SMTP code for VBA?

Chuck Grimsby <c.grimsby@worl dnet.att.net.in valid> wrote:
[color=blue]
>I've posted code to do SMTP via the winSock control previously in this
>newsgroup. Search for it at Google if you want.[/color]

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

[LaurenW]

Re: SMTP code for VBA?

On Mon, 06 Oct 2003 22:47:07 GMT, Tony Toews <ttoews@teluspl anet.net>
wrote:
[color=blue]
>Chuck Grimsby <c.grimsby@worl dnet.att.net.in valid> wrote:
>[color=green]
>>I've posted code to do SMTP via the winSock control previously in this
>>newsgroup. Search for it at Google if you want.[/color]
>
>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[/color]

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

[Tony Toews]

Re: SMTP code for VBA?

LaurenW <replytogroup@n ospam.zap> wrote:
[color=blue]
>Tony, I cannot find ANY text on your site labeled "Directly via the
>Winsock". Help![/color]

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