(Excel) Download POP3 Email to MIME Strings

Download the email from a POP3 mailbox directly into MIME strings, without parsing into email objects.

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"

' First, get the complete set of UIDLs for the email in the POP3 mailbox:

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

' Download the email as MIME strings (no parsing of the MIME)

Set saMime = mailman.FetchMultipleMime(saUidls)
If (mailman.LastMethodSuccess <> True) Then
    Debug.Print mailman.LastErrorText

    Exit Sub
End If

' MIME strings may be loaded into email objects:

Dim email As Chilkat.Email
Set email = Chilkat.NewEmail
For i = 0 To saMime.Count - 1
    success = email.SetFromMimeText(saMime.GetString(i))
    Debug.Print "From: "; email.From
    Debug.Print "Subject: "; email.Subject
Next