(Excel) IMAP Delete Old Email (before a specified date)

Demonstrates how to delete email older than a particular date.

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
' Use your IMAP server domain.  This example 

success = imap.Connect("my-imap-server-domain.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

' Get message ID's for emails older than 1/1/2018


fetchUids = True
Set messageSet = imap.Search("SENTBEFORE 01-Jan-2018",fetchUids)
If (imap.LastMethodSuccess = False) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' If desired, we can examine the Subject of each email to be deleted..

i = 0

count = messageSet.Count
Do While i < count

    Set email = imap.FetchSingleHeader(messageSet.GetId(i),True)
    If (imap.LastMethodSuccess = True) Then
        Debug.Print email.Subject

    End If

    i = i + 1
Loop

' Set the Deleted flag for each message:
success = imap.SetFlags(messageSet,"Deleted",1)
If (success <> True) Then
    Debug.Print imap.LastErrorText

    Exit Sub
End If

' Expunge and close the mailbox.
success = imap.ExpungeAndClose()
If (success <> True) Then
    Debug.Print imap.LastErrorText

    Exit Sub
End If

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