(Excel) Download POP3 Email using UIDLs

Demonstrates how to download POP3 email by first getting the complete set of UIDLs and then downloading email by calling FetchEmail for each UIDL. This is equivalent to calling CopyMail, except your application can process each email as it arrives instead of waiting for the entire bundle to be downloaded. Also, it's better protection against potential out-of-memory issues if your mailbox has a very large number of messages. There is no performance difference between fetching emails individually vs. calling CopyMail.

Download Excel Class Modules Chilkat Excel Class Modules

' 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.
Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

' Set the POP3 server's hostname
mailman.MailHost = "pop.someMailServer.com"

' Set the POP3 login/password.
mailman.PopUsername = "myLogin"
mailman.PopPassword = "myPassword"


Set sa = mailman.GetUidls()
If (mailman.LastMethodSuccess <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If


i = 0

n = sa.Count

Do While i < n

    uidl = sa.GetString(i)


    Set email = mailman.FetchEmail(uidl)
    If (mailman.LastMethodSuccess <> True) Then
        Debug.Print mailman.LastErrorText

        Exit Sub
    End If

    Debug.Print "From: "; email.From
    Debug.Print "Subject: "; email.Subject

    i = i + 1
Loop

Dim success As Boolean
success = mailman.Pop3EndSession()