473,378 Members | 1,680 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,378 software developers and data experts.

SMTP retrieve emails through Access

Hi,

I use Access to send emails through SMTP. I'd like to mirror the
process and retrieve emails from my SMTP/Pop3 server without the
intermediary of Outlook. I don't want to spend a lot of money on 3rd
party applications.

Can I do this through code or is there some reason why it is not
doable? I've hunted through the net but all I've got are references to
commercial applications. A pointer to sample code would be much
appreciated.

Thanks in advance for any help.

Regards

Emmett Power
Nov 12 '05 #1
5 3231
Em****@Silico-Research.com (Emmett Power) wrote:
I use Access to send emails through SMTP. I'd like to mirror the
process and retrieve emails from my SMTP/Pop3 server without the
intermediary of Outlook. I don't want to spend a lot of money on 3rd
party applications.

Can I do this through code or is there some reason why it is not
doable? I've hunted through the net but all I've got are references to
commercial applications. A pointer to sample code would be much
appreciated.


There is some stuff although not exactly what you are looking for at the Winsock
section at the Access Email FAQ at my website.

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
Tony Toews <tt****@telusplanet.net> wrote in message news:<s6********************************@4ax.com>. ..
Em****@Silico-Research.com (Emmett Power) wrote:
I use Access to send emails through SMTP. I'd like to mirror the
process and retrieve emails from my SMTP/Pop3 server without the
intermediary of Outlook. I don't want to spend a lot of money on 3rd
party applications.

Can I do this through code or is there some reason why it is not
doable? I've hunted through the net but all I've got are references to
commercial applications. A pointer to sample code would be much
appreciated.


There is some stuff although not exactly what you are looking for at the Winsock
section at the Access Email FAQ at my website.

Tony


Tony,

Thanks for the help. I've looked on your site and I'm not sure what
pages you're referring to. Can you give me a bit more of a pointer?

Thanks

Emmett Power
Nov 12 '05 #3
Em****@Silico-Research.com (Emmett Power) wrote:
I've looked on your site and I'm not sure what
pages you're referring to. Can you give me a bit more of a pointer?


"Directly via the Winsock" pages are the closest to what you want.

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
> Thanks for the help. I've looked on your site and I'm not sure what
pages you're referring to. Can you give me a bit more of a pointer?

Thanks

Emmett Power


You might want to poke around at http://www.slipstick.com/ and see what
you can find there.
Nov 12 '05 #5
Em****@Silico-Research.com (Emmett Power) wrote in message news:<6e**************************@posting.google. com>...
Hi,

I use Access to send emails through SMTP. I'd like to mirror the
process and retrieve emails from my SMTP/Pop3 server without the
intermediary of Outlook. I don't want to spend a lot of money on 3rd
party applications.

Can I do this through code or is there some reason why it is not
doable? I've hunted through the net but all I've got are references to
commercial applications. A pointer to sample code would be much
appreciated.

Thanks in advance for any help.

Regards

Emmett Power Can I do this through code or is there some reason why it is not
doable?


Well, yes, it can be done through code, but at what level are you
talking about?

You can talk to wsock32.dll directly through ms-access's vba, but you
better have a pretty good knowledge of how sockets work, how api calls
are executed from vba (Dan Applemen's "Programmer's guide to the Win32
API"), how the windows api works (you have to process "socket
messages" I.E. events), and have more than just a few hours of spare
time. This level is surprisingly simple once and if you get there, but
getting there is very, very tricky. If you get there you still have to
write POP3 and SMTP protocols to send and receive and depending on
what you’re doing, MIME to encode and decode email.

You can skip talking to wsock32.dll directly by using a winsock .ocx.
MS makes one, and a shareware (free) one comes with Carl Franklin's
book "Visual Basic Internet Programming". It's a nice little control
named DsSock32.ocx, and he covers (with examples, cheesy, but
functional) the POP3 and SMTP protocols you'll need to use it. Leaving
only MIME (if you need it) to write, but like talking to wsock32.dll,
MIME is surprisingly simple once and if you get there, but getting
there is tricky.

It is my understanding that there is also POP3 and SMTP controls that
include MIME and function at the message level, just hand it the
message and a few other things and it does the rest. I'm so not an
expert on these, but there may be a cheap or free set around. (google
time)

Take care with any free controls that talk on the internet, people
that write them are not always nice, so keep an eye on your firewall
log when testing them out. In general, once your firewall allows a
control to access the internet, that control can do just about
anything the programmer of that control wants.
(very not good)

My recommendations would depend on your view of the time vs. money
issue so:
1) If you don't need MIME, DsSock32.ocx and Carl Franklin's book will
have you up and going in a weekend.
2) If you do need MIME, google for message level POP3 and SMTP
controls that includes it, all toll I have probably 4-6 weeks into
MIME over the years, so paying some money for a control may not be a
bad deal.

good luck
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: David | last post by:
Hi Group, I'm having a few problems with getting an SMTP server configured on my Windows 2000 Server web server. My web server is co-located at my hosts and i use VNC to remotely access the web...
5
by: Emmett Power | last post by:
Hi, I use Access to send emails through SMTP. I'd like to mirror the process and retrieve emails from my SMTP/Pop3 server without the intermediary of Outlook. I don't want to spend a lot of...
7
by: Razzie | last post by:
Hey all, I need to connect to an SMTP server and get a notification when it gets a new mail to send. I want to be able to 'read' that email (retrieve recipient information for example). Is that...
5
by: R. Ian Lee | last post by:
I'm using the System.Web.Mail.SmtpMail object (.NET 1.1) to send email from an ASP.NET application. Everything works fine when I run it from Windows 2000 Server, but not from WinXP Pro. Is it...
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...
4
by: =?Utf-8?B?dHBhcmtzNjk=?= | last post by:
I have a web page that at the click of a button must send a bunch (1000+) emails. Each email is sent individually. I have the code working fine, using Mail Message classes and smtp and all that. ...
0
by: =?Utf-8?B?UmljaA==?= | last post by:
Hello, My company will be hosting a webcast, and I need to send out 2000 individual emails to people who signed up (for login information...). I created an smtp app that I can loop through...
5
by: Carmine [www.thetotalsite.it] | last post by:
Hi everyone, I get a really odd error while using SMTPClient.Send() function in ASP.Net. The error is the following: Dim smtp As New Net.Mail.SmtpClient("smtp.thetotalsite.it", 25) Dim bodyMSG...
8
by: ayush patel | last post by:
Hi Everybody, i have a problem with smtp server. i developed an application on my local machine and it runs fine.it uses our smtp server to send emails. but when i uploaded the app on to the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.