(Excel) How to Download Messages in MessageSet One at a Time

If a message set contains a huge number of emails, it's NOT a good idea to try to download all at once into an email bundle using a method such as FetchBundle. It's better to interate over the message numbers in the set to download one by one.

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.

' This example copies an email from one mailbox to another.
Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' Connect using TLS.
imap.Ssl = True
imap.Port = 993

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

' Authenticate
success = imap.Login("email_account_login","email_account_password")
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

' Search for messages having "Test email" in the subject.

fetchUids = True

Set messageSet = imap.Search("ALL",fetchUids)
If (imap.LastMethodSuccess <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

Debug.Print "Number of messages = "; messageSet.Count


i = 0
Do While i < messageSet.Count

    Set email = imap.FetchSingle(messageSet.GetId(i),fetchUids)
    If (imap.LastMethodSuccess <> True) Then
        Debug.Print imap.LastErrorText

        Exit Sub
    End If

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

    i = i + 1
Loop

Debug.Print "OK"