(Excel) Read IMAP Email Headers

Call FetchHeaders to download only the email headers.

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 imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' Connect to an IMAP server.
' Use TLS
imap.Ssl = True
imap.Port = 993

success = imap.Connect("imap.someMailServer.com")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Login
success = imap.Login("****","****")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Select an IMAP mailbox
success = imap.SelectMailbox("Inbox")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' We can choose to fetch UIDs or sequence numbers.

fetchUids = True
' Get the message IDs of all the emails in the mailbox
Set messageSet = imap.Search("ALL",fetchUids)
If (imap.LastMethodSuccess <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' When downloading headers, each email object contains
' (obviously) the headers, but the body will be missing.
' Also, attachments will not be included.  However, it is
' possible to get information about the attachments
' as well as the complete size of the email.

Set bundle = imap.FetchHeaders(messageSet)
If (imap.LastMethodSuccess <> True) Then

    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Loop over the email objects and display information
' about each:

For i = 0 To bundle.MessageCount - 1

    Set email = bundle.GetEmail(i)

    ' Display the From and Subject
    Debug.Print email.From
    Debug.Print email.Subject

    ' Display the recipients:

    For j = 0 To email.NumTo - 1
        name = email.GetToName(j)
        addr = email.GetToAddr(j)
        Debug.Print name; ", "; addr
    Next
    For j = 0 To email.NumCC - 1
        name = email.GetCcName(j)
        addr = email.GetCcAddr(j)
        Debug.Print name; ", "; addr
    Next

    ' Show the total size of the email, including body and attachments:
    Debug.Print email.Size

    ' When a full email is downloaded, we would use the
    ' email.NumAttachments property in conjunction with the
    ' email.GetMailAttach* methods.
    ' However, when an email object contains only the header,
    ' we need to access the attachment info differently:

    numAttach = imap.GetMailNumAttach(email)
    For j = 0 To numAttach - 1
        Debug.Print imap.GetMailAttachFilename(email,j)

        attachSize = imap.GetMailAttachSize(email,j)
        Debug.Print "    size = "; attachSize; " bytes"
    Next

    Debug.Print "--"

Next

' Disconnect from the IMAP server.
success = imap.Disconnect()