(Excel) Find the "Sent" IMAP Mailbox

Find the "Sent" IMAP mailbox. Also finds the Junk and Trash mailboxes..

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.

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

imap.Ssl = True
imap.Port = 993

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

' Login or authenticate in some way..
success = imap.Login("your_login","your_password")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Get the list of mailboxes.

refName = ""

wildcardedMailbox = "*"


Set mboxes = imap.ListMailboxes(refName,wildcardedMailbox)
If (imap.LastMethodSuccess = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' The mailbox with the "/Sent" flag is the "Sent" mailbox.
' Likewise for Junk and Trash..

i = 0
Do While i < mboxes.Count
    If (mboxes.HasFlag(i,"\Sent") = True) Then
        Debug.Print "Sent mailbox: "; mboxes.GetName(i)
    End If

    If (mboxes.HasFlag(i,"\Junk") = True) Then
        Debug.Print "Junk mailbox: "; mboxes.GetName(i)
    End If

    If (mboxes.HasFlag(i,"\Trash") = True) Then
        Debug.Print "Trash mailbox: "; mboxes.GetName(i)
    End If

    i = i + 1
Loop

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