(Excel) Delete Individual Emails from POP3 Mailbox

Demonstrates how to delete individual emails from a POP3 mailbox.

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.

' The mailman object is used for receiving (POP3) 
' and sending (SMTP) email.
Dim mailman As Chilkat.MailMan
Set mailman = Chilkat.NewMailMan

' Set the POP3 server's hostname
mailman.MailHost = "pop.someMailServer.com"

' Set the POP3 login/password.
mailman.PopUsername = "myLogin"
mailman.PopPassword = "myPassword"

' Set the ImmediateDelete property = False
' When the DeleteEmail method is called, the POP3 session
' will remain open and the emails will be deleted all at once
' when the session closes.
mailman.ImmediateDelete = False

' Download email headers.  

Set bundle = mailman.GetAllHeaders(1)
If (mailman.LastMethodSuccess = False) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If


i = 0

Do While i < bundle.MessageCount
    Set email = bundle.GetEmail(i)

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

    ' If you decide the email is to be deleted, call DeleteEmail.
    ' This marks the email for deletion on the POP3 server.

    success = mailman.DeleteEmail(email)
    If (success <> True) Then
        Debug.Print mailman.LastErrorText
        Exit Sub
    End If

    i = i + 1
Loop

' Make sure the POP3 session is ended to finalize the deletes.
success = mailman.Pop3EndSession()
If (success <> True) Then
    Debug.Print mailman.LastErrorText
End If

Debug.Print "Success!"