(Excel) POP3 SSL - Read POP3 Email over TLS/SSL on Port 995

Demonstrates how to connect via TLS/SSL to a POP3 server and read email. This assumes that the POP3 server supports SSL.

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.

' 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.gmail.com"

' Set the POP3 login/password.
mailman.PopUsername = "****@gmail.com"
mailman.PopPassword = "****"

' Indicate that we want TLS/SSL.  Also, set the port to 995:
mailman.MailPort = 995
mailman.PopSsl = True


Set bundle = mailman.CopyMail()
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)

    ' Display the From email address and the subject.
    Debug.Print "From: "; email.From
    Debug.Print "Subject: "; email.Subject

    i = i + 1
Loop