(Excel) Read All Email from POP3 Inbox by Message Numbers

Demonstrates how to read all of the email from a POP3 inbox by fetching each email by it's message number.

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.

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"

' Get the number of messages in the mailbox.

numMessages = mailman.GetMailboxCount()

' Message numbers are specific to a POP3 session. 
' If a maildrop (i.e. inbox)  contains 10 messages, 
' the message numbers will be 1, 2, 3, ... 10. 
' If message number 1 is deleted and a new POP3 session 
' is established, there will be 9 messages numbered 1, 2, 3, ... 9. 


i = 0

Do While i < numMessages

    Set email = mailman.FetchByMsgnum(i)
    If (mailman.LastMethodSuccess <> True) Then
        Debug.Print mailman.LastErrorText
        Exit Sub
    End If

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

    i = i + 1

Loop