(Excel) Read POP3 Mail Headers

Reads the header for each email in a POP3 mailbox and display the FROM and SUBJECT header fields.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes 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 = "****"
mailman.PopPassword = "****"

' Read mail headers and one line of the body.

Set bundle = mailman.GetAllHeaders(1)
If (mailman.LastMethodSuccess = False) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If


i = 0

Do While i < bundle.MessageCount
    Set email = bundle.GetEmail(i)

    ' Display the From email address and the subject.
    Debug.Print "From: "; email.From
    Debug.Print "Subject: "; email.Subject

    i = i + 1
Loop