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

Send SMTP Email from Access 2003

P: n/a
Is there a simple way to send SMTP email from Access VBA?

Mike
m charney at dunlap hospital dot org
Apr 18 '06 #1
Share this Question
Share on Google+
10 Replies


P: n/a
Mike Charney schrieb:
Is there a simple way to send SMTP email from Access VBA?


google for "blat".

Best regards
Martin
Apr 18 '06 #2

P: n/a

"Martin Schneider" <ma**************@illusion-factory.de> wrote in message
news:4a************@individual.net...
Mike Charney schrieb:
Is there a simple way to send SMTP email from Access VBA?


google for "blat".

Best regards
Martin


I did a google for blat and the server seems to be dead. Is there another
way?
Apr 18 '06 #3

P: n/a
Mike Charney schrieb:
I did a google for blat and the server seems to be dead. Is there another
way?


Hmmmm. You're right - don't know what happened.

But looking into the "Cache" page of that google hit then clicking
"Download" leads to...

http://sourceforge.net/project/showf...group_id=81910

Best regards,
Martin
Apr 18 '06 #4

P: n/a

"Martin Schneider" <ma**************@illusion-factory.de> wrote in message
news:4a************@individual.net...
Mike Charney schrieb:
I did a google for blat and the server seems to be dead. Is there another
way?


Hmmmm. You're right - don't know what happened.

But looking into the "Cache" page of that google hit then clicking
"Download" leads to...

http://sourceforge.net/project/showf...group_id=81910

Best regards,
Martin


Whats the difference between using blat and the built in smtp service that
comes with IIS on Windows XP Pro?

Mike
Apr 18 '06 #5

P: n/a
I looked for a simple way to use SMTP to send email from Access but it
wasn't simple at all. We ended up creating an Access add-in product,
Total Access Emailer, to address this need.

If you want to try a copy for free, visit our web site for the beta of
the new version. The Access 2003 beta version is available as a beta,
but we'll have versions of Access 97, 2000, and 2002 when we ship. Of
course the existing version has been shipping for some time.

Total Access Emailer lets you create custom emails for each email
address in your list. The new version supports the ability to embed
tables, queries, and reports in your email, which can be in text or
HTML format. The new feature of using your Access report generator to
create a custom report with all the groupings, summaries, etc. as your
HTML email is pretty powerful. You can of course, filter the table,
query and report for each recipient, use it as your message, or add is
an attachment.

Hope you like it.

Luke Chung
President
FMS, Inc.
http://www.fmsinc.com

Apr 18 '06 #6

P: n/a
I looked at your web site. This is great product, but it is way more then
what I want.

All I want to do is send an email, no attachments, to an email address on my
exchange server. I do not have an email client on the system. I am looking
for a way to send an SMTP email directly from an MS-Access module.

Mike

"FMS Development Team" <fm****@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
I looked for a simple way to use SMTP to send email from Access but it
wasn't simple at all. We ended up creating an Access add-in product,
Total Access Emailer, to address this need.

If you want to try a copy for free, visit our web site for the beta of
the new version. The Access 2003 beta version is available as a beta,
but we'll have versions of Access 97, 2000, and 2002 when we ship. Of
course the existing version has been shipping for some time.

Total Access Emailer lets you create custom emails for each email
address in your list. The new version supports the ability to embed
tables, queries, and reports in your email, which can be in text or
HTML format. The new feature of using your Access report generator to
create a custom report with all the groupings, summaries, etc. as your
HTML email is pretty powerful. You can of course, filter the table,
query and report for each recipient, use it as your message, or add is
an attachment.

Hope you like it.

Luke Chung
President
FMS, Inc.
http://www.fmsinc.com

Apr 18 '06 #7

P: n/a
Hi Martin,

This is 3 ways to send email from Access

With Blat.dll :
http://www.logicielappui.com/tips/AccXP_MailDLL.zip

With Winsock (API only)
http://www.logicielappui.com/tips/AccXP_MailAPI.zip

With MAPI (Outlook, Outlook Expess and Lotus Note)
http://www.logicielappui.com/tips/AccXP_Mail.zip
Regards

Robert Simard
Logipro
For my all tips :
http://www.logicielappui.com/tips
"Martin Schneider" <ma**************@illusion-factory.de> a écrit dans le
message de news: 4a************@individual.net...
Mike Charney schrieb:
Is there a simple way to send SMTP email from Access VBA?


google for "blat".

Best regards
Martin

Apr 18 '06 #8

P: n/a
The method I used is as follows. I have a table which contains all the email
addresses I need to mail and have a query ("Qry_George_List" in my case)
based on this table.

The following code creates a string of all the mail addresses separated with
"; " (minus the quotes).

Dim rstML As New ADODB.Recordset
Dim strList As String

rstML.Open "qry_george_list", CurrentProject.Connection, adOpenStatic,
adLockReadOnly
Do Until rstML.EOF
strList = strList & rstML!address & "; " 'replace address with the
field you use!
rstML.MoveNext
Loop
rstML.Close
Set rstML = Nothing
strList = Left(strList, Len(strList) - 2) 'cut off the last ; and Space

==============================================

The following code sends the email

Public Sub SendMail()
Dim oOApp As Outlook.Application
Dim oOMail As Outlook.MailItem

Set oOApp = CreateObject("Outlook.Application")
Set oOMail = oOApp.CreateItem(olMailItem)

With oOMail
..To = SrList ' Here the To field of the email is populated with the value of
StrList
..CC = ""
..Subject = ""
..Body = ""
..Send
End With
End Sub
Then to send the mail, just call SendMail.

Hope this is what your after,

Mark

"Mike Charney" <no*****@everything.net> wrote in message
news:ok*******************@newssvr21.news.prodigy. com...
I looked at your web site. This is great product, but it is way more then
what I want.

All I want to do is send an email, no attachments, to an email address on
my exchange server. I do not have an email client on the system. I am
looking for a way to send an SMTP email directly from an MS-Access module.

Mike

"FMS Development Team" <fm****@gmail.com> wrote in message
news:11**********************@i39g2000cwa.googlegr oups.com...
I looked for a simple way to use SMTP to send email from Access but it
wasn't simple at all. We ended up creating an Access add-in product,
Total Access Emailer, to address this need.

If you want to try a copy for free, visit our web site for the beta of
the new version. The Access 2003 beta version is available as a beta,
but we'll have versions of Access 97, 2000, and 2002 when we ship. Of
course the existing version has been shipping for some time.

Total Access Emailer lets you create custom emails for each email
address in your list. The new version supports the ability to embed
tables, queries, and reports in your email, which can be in text or
HTML format. The new feature of using your Access report generator to
create a custom report with all the groupings, summaries, etc. as your
HTML email is pretty powerful. You can of course, filter the table,
query and report for each recipient, use it as your message, or add is
an attachment.

Hope you like it.

Luke Chung
President
FMS, Inc.
http://www.fmsinc.com


Apr 19 '06 #9

P: n/a
Mike Charney schrieb:
Whats the difference between using blat and the built in smtp service that
comes with IIS on Windows XP Pro?


You asked for "simple way to send SMTP email", not "how to send SMTP
email via XP pro and IIS". There you are.

Best regards,
Martin
Apr 19 '06 #10

P: n/a
In order to not reveal your friend's and relative's e-mail addresses,
the code should be modified to place the recipient's addresses in the
BC or BCC field and your e-mail address in the To field. I haven't
tried it but following is the modified code...

With oOMail
..To ="yo*******@yourisp.com"
..BC = SrList ' Here the BC field is populated with the value of StrList
..CC = ""
..Subject = ""
..Body = ""
..Send

May 10 '06 #11

This discussion thread is closed

Replies have been disabled for this discussion.