View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default CDO to Retrieve E-mail

Read this webpage

I don't know how much you understand network protocols.

I found information to open a Telnet session to get email. A telnet
oprotocol goes back to the early 1970's. It was 1st developed for Telnet
terminals that were operating at 75 Baud (75 bits a second). That is about
one line of data a second. Very slow.

Telnet now will run at you connection speed which is probably greater than 1
million bits a second. But it requires issuing one comand and then waiting
for the response. and the return message will be a string that you will have
to process. The response could be an email message or an error message. You
will have to intepret each type of response in your software. This may be
complicated. I haven't tried it myself. You may want to open an interactive
window where the user will type commands and get responses on the window.

FTP is similar to Telnet put will put the results into a file instead
returning the message(s) into a file. Again this could be complicated.

I think the simplies approach would be to use an email program.

"Albert" wrote:

Hi Joel,
Thanks for your quick response. I'm thinking something more in the lines of
POP. Could you give me some suggestions for the commands?
Thanks,
Albert C.

"Joel" wrote:

the code would depend on the format your e-mail server used. for example a
POP server would use different commands than other servers. If your e-mail
account had web access you can download the email using a werb browser
approach.

"ryguy7272" wrote:

I think you need Outlook, or some kind of SMTP (you could use Google) to do
it for you. Maybe this will help:
http://www.troyeesoft.com/offline-link-extractor.htm

Good luck,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Albert" wrote:

Hello!

I have succesfully used Ron DeBruin's CDO instructions to set up a very nice
email sending application.

Is there a way similar to CDO to check and retrieve emails without going
through Outlook or any other email client?

Thanks in advance,

Albert C.