Visual FoxPro

Reading Unread POP3 Email

The POP3 protocol cannot determine which emails are "unread," and pure POP3 servers do not store this information. Servers like Exchange Server, offering both POP3 and IMAP interfaces, do contain read/unread data, but it's only accessible through IMAP. Email clients like Outlook and Thunderbird store read/unread statuses on the client side. The example demonstrates using UIDLs to track and manage "unread" emails. Visual FoxPro

LOCAL lnSuccess
LOCAL loMailman
LOCAL lcSeenUidlsPath
LOCAL loSbXml
LOCAL loHtSeenUidls
LOCAL loFac
LOCAL loStUidls
LOCAL loStUnseenUidls
LOCAL lcUidl
LOCAL i
LOCAL lnCount
LOCAL loEmail

lnSuccess = 0

* This example requires the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

* The mailman object is used for receiving (POP3) 
* and sending (SMTP) email.
loMailman = CreateObject('Chilkat.MailMan')

* Set the POP3 server's hostname
loMailman.MailHost = "pop.example.com"

* Set the POP3 login/password.
loMailman.PopUsername = "***"
loMailman.PopPassword = "***"

* Keep a records of already-seen UIDLs in hash table serialized to an XML file.
lcSeenUidlsPath = "c:/temp/seenUidls.xml"

loSbXml = CreateObject('Chilkat.StringBuilder')
loHtSeenUidls = CreateObject('Chilkat.Hashtable')
loFac = CreateObject('Chilkat.FileAccess')
IF (loFac.FileExists(lcSeenUidlsPath) = 1) THEN
    lnSuccess = loSbXml.LoadFile(lcSeenUidlsPath,"utf-8")
    IF (lnSuccess = 0) THEN
        ? loSbXml.LastErrorText
        RELEASE loMailman
        RELEASE loSbXml
        RELEASE loHtSeenUidls
        RELEASE loFac
        CANCEL
    ENDIF

    loHtSeenUidls.AddFromXmlSb(loSbXml)
ENDIF

* Get the complete list of UIDLs on the mail server.
loStUidls = CreateObject('Chilkat.StringTable')
lnSuccess = loMailman.FetchUidls(loStUidls)
IF (lnSuccess = 0) THEN
    ? loMailman.LastErrorText
    RELEASE loMailman
    RELEASE loSbXml
    RELEASE loHtSeenUidls
    RELEASE loFac
    RELEASE loStUidls
    CANCEL
ENDIF

* Build a list of unseen UIDLs
loStUnseenUidls = CreateObject('Chilkat.StringTable')

i = 0
lnCount = loStUidls.Count
DO WHILE i < lnCount
    lcUidl = loStUidls.StringAt(i)
    IF (loHtSeenUidls.Contains(lcUidl) <> 1) THEN
        loStUnseenUidls.Append(lcUidl)
    ENDIF

    i = i + 1
ENDDO

IF (loStUnseenUidls.Count = 0) THEN
    ? "No unseen emails!"
    RELEASE loMailman
    RELEASE loSbXml
    RELEASE loHtSeenUidls
    RELEASE loFac
    RELEASE loStUidls
    RELEASE loStUnseenUidls
    CANCEL
ENDIF

* Download the unseen emails, adding each UIDL to the "seen" hash table.
loEmail = CreateObject('Chilkat.Email')

lnCount = loStUnseenUidls.Count
i = 0
DO WHILE i < lnCount
    * Download the full email.
    lcUidl = loStUnseenUidls.StringAt(i)
    lnSuccess = loMailman.FetchByUidl(lcUidl,0,0,loEmail)
    IF (lnSuccess = 0) THEN
        ? loMailman.LastErrorText
        RELEASE loMailman
        RELEASE loSbXml
        RELEASE loHtSeenUidls
        RELEASE loFac
        RELEASE loStUidls
        RELEASE loStUnseenUidls
        RELEASE loEmail
        CANCEL
    ENDIF

    ? STR(i)
    ? "From: " + loEmail.From
    ? "Subject: " + loEmail.Subject

    * Add this UIDL to the "seen" hash table.
    loHtSeenUidls.AddStr(lcUidl,"")

    i = i + 1
ENDDO

loMailman.Pop3EndSession()

* Update the "seen" UIDLs file.
loSbXml.Clear()
loHtSeenUidls.ToXmlSb(loSbXml)
lnSuccess = loSbXml.WriteFile(lcSeenUidlsPath,"utf-8",0)
IF (lnSuccess = 0) THEN
    ? loSbXml.LastErrorText
    RELEASE loMailman
    RELEASE loSbXml
    RELEASE loHtSeenUidls
    RELEASE loFac
    RELEASE loStUidls
    RELEASE loStUnseenUidls
    RELEASE loEmail
    CANCEL
ENDIF

? "Success."

RELEASE loMailman
RELEASE loSbXml
RELEASE loHtSeenUidls
RELEASE loFac
RELEASE loStUidls
RELEASE loStUnseenUidls
RELEASE loEmail