473,320 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

SMTP code for VBA?

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
7 15415
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

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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: bivin | last post by:
hai i am requesting your technical support. please help me. i have been working with this for five days. the problem is relating with the smtp. i am trying to send an email from the asp.net...
4
by: Tushar | last post by:
Please help: I found some of the following information in messeges in this group but I would like someone to confirm them please. I would like to use the following web-services / ASP.Net code to...
34
by: antonyliu2002 | last post by:
I've set up the virtual smtp server on my IIS 5.1 like so: 1. Assign IP address to "All Unassigned", and listen to port 25. 2. Access Connection granted to "127.0.0.1". 3. Relay only allow...
2
by: oliu321 | last post by:
Hi, First I am not trying to write a client to talk with hotmail straightly. I am trying to write some codes to send emails through a SMTP server. I wrote a C++ version using pure socket...
11
by: ibiza | last post by:
Hi all, I am trying to use the System.Net.Mail class for the first time, with ASP.NET 2.0. I setup everything according to http://www.codeproject.com/aspnet/EasySMTP_package.asp, which gives...
2
by: =?Utf-8?B?QWRl?= | last post by:
HI All, I am encountering the following error when I try to send an email through a SMTP server. I believe the problem lies with the authentication part when the network crednetials are used,...
6
pbmods
by: pbmods | last post by:
I feel almost embarrassed to post in this forum, but I can't exactly pick my clients' technologies, so here we are. I'm supporting a client project written in ASP. Part of the project that...
13
by: jcor | last post by:
Hi, I'm trying some code to send a mail with my script. This is it: #!/usr/bin/perl use Net::SMTP; my $smtp_server='62.193.245.15'; my $smtp = Net::SMTP->new($smtp_server) or die "Can't Open...
5
by: jimhill10 | last post by:
I have a perl script that creates an email attachment file from POST data on a web page. This works just fine. I want to customize the email body to contain all of the text data from the file...
4
by: eruth | last post by:
Hi all, I'm trying to send an e-mail from a vb.net web form. I can create the message, but when it comes to actually sending it I get the following error. "Mailbox name not allowed. The server...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.