(Excel) Scan for Emails with Attachments and Save Attachments to Files

Scan for emails with attachments and save attachments.

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("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

' 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

' Fetch the email headers into a bundle object:

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

    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Scan for emails with attachments, and save the attachments
' to a sub-directory.

For i = 0 To bundle.MessageCount - 1

    Set email = bundle.GetEmail(i)

    ' Does this email have attachments?
    ' Use GetMailNumAttach because the attachments
    ' are not actually in the email object because
    ' we only downloaded headers.
    ' (Had we downloaded the full emails by
    ' calling mailman.FetchBundle, we could look
    ' at the email object's NumAttachments property.)

    numAttach = imap.GetMailNumAttach(email)

    If (numAttach > 0) Then
        ' Download the entire email and save the
        ' attachments. (Remember, we 
        ' need to download the entire email because
        ' only the headers were previously downloaded.
        ' If the entire emails were downloaded by
        ' calling FetchBundle instead of FetchHeaders,
        ' this would not be necessary.

        ' The ckx-imap-uid header field is added when
        ' headers are downloaded.  This makes it possible
        ' to get the UID from the email object.

        uidStr = email.GetHeaderField("ckx-imap-uid")

        uid = CLng(uidStr)

        Set fullEmail = imap.FetchSingle(uid,True)
        If (imap.LastMethodSuccess = True) Then
            success = fullEmail.SaveAllAttachments("attachmentsDir")

        End If

        For j = 0 To numAttach - 1

            filename = imap.GetMailAttachFilename(email,j)
            Debug.Print filename
        Next

    End If

Next

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