(Excel) IMAP Download All Email One at a Time

Demonstrates how to download every email in an IMAP mailbox one at a time as a MIME string or as an email object. (The MIME contains the full contents of the email including all attachments.)

Download Excel Class Modules Chilkat Excel Class Modules

Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' 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("myLogin","myPassword")
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

' Once the mailbox is selected, the NumMessages property
' will contain the number of messages in the mailbox.
' You may loop from 1 to NumMessages to
' fetch each message by sequence number.


bUid = False


n = imap.NumMessages
For i = 1 To n

    ' Download the email by sequence number.
    mimeStr = imap.FetchSingleAsMime(i,bUid)

    ' ... your application may process each MIME string...
Next

' An alternative is to download each email in the form of an
' email object, like this:

For i = 1 To n

    ' Download the email by sequence number.
    Set email = imap.FetchSingle(i,bUid)

    ' ... your application may process the email object...

Next

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