(Excel) Process New Email by Scanning for Senders

Scan email and save application-selected emails to EML files with unique filenames.

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

' 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

' Fetch messages from the mailbox using a search criteria.
' This example finds NEW emails: these are emails that have the RECENT flag set, but not the SEEN flag:
Set messageSet = imap.Search("NEW",fetchUids)
If (imap.LastMethodSuccess = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' This example will download headers, and then download
' the full email for those emails sent from a contact
' in our database.

' 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 = False) Then

    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Loop over the email objects...

i = 0

numEmails = bundle.MessageCount
Do While i < numEmails

    Set email = bundle.GetEmail(i)

    ' The sender's email address and name are available
    ' in the From, FromAddress, and FromName properties.
    ' If the sender is "Chilkat Support <support@chilkatsoft.com",
    ' then the From property will hold the entire string.
    ' the FromName property contains"Chilkat Support",
    ' and the FromAddress property contains "support@chilkatsoft.com"
    Debug.Print email.From
    Debug.Print email.FromAddress
    Debug.Print email.FromName

    ' Assume at this point your code checks to see if the sender
    ' is one in your contacts database.  If so, this is
    ' the code you would write to download the entire
    ' email and save it to a file.

    ' 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
        ' You may use the GenerateFilename method to
        ' generate a unique filename...

        filename = fullEmail.GenerateFilename()

        ' SaveEml saves the entire email, including attachments.
        success = fullEmail.SaveEml(filename)

    End If

    Debug.Print "--"

    i = i + 1
Loop

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