How to receive POP mail using VB6 and save into Access MDB

Posted on 2005-05-06
Last Modified: 2013-12-25
Hi Experts

Need to be able to read and save POP email from POP server and save into Access MDB. It's the POP bit I need help with. If email has attachment, I don't want it but need to know how to deal with it.

From another solution (Q_20842674) SweatCoder sent someone some code which sounds like it could be what I need (if you are listening!!)

Hope you can help!
Question by:JoshuaAMS
    LVL 13

    Expert Comment

    Use a 3rd party POP object, like Easy Mail Objects from - works for me. It's really easy to get the messages you need, you have full access to the message, headers, attachments. Just save the strings in a MDB, no big deal. :)
    Oops: it's payware, I hope that wasn't a criteria :))

    Author Comment

    Sorry, should have specified, I really would prefer not to use a third party thing and have my 'own' code running it. It's a learning thing ;-)

    I have some VB experience and should be able to figure it out once I am set in the right direction, sample code etc.
    LVL 13

    Accepted Solution

    OK, then lets see ...
    You should understand the POP3 protocol, it's not hard:
    Then from the same site there is an example:
    using the winsock.dll. Once you have the message, just save it to a db. You can play with POP3 using telnet (i.e. telnet 110)
    Have fun :)

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
    If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now