(Excel) Read Gmail POP3 Mailbox

Reads the header for each email in a GMail POP3 mailbox and displays the FROM and SUBJECT header fields. In your GMail "Forwarding and POP" settings, be sure to select "When messages are accessed with POP keep Gmail's copy in the Inbox".

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 GMail account POP3 properties.
mailman.MailHost = "pop.gmail.com"
mailman.PopUsername = "myLogin"
mailman.PopPassword = "myPassword"
mailman.PopSsl = True
mailman.MailPort = 995

' Read mail headers and one line of the body.
' To get the full emails, call CopyMail instead (no arguments)

Set bundle = mailman.GetAllHeaders(1)

If (mailman.LastMethodSuccess <> True) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If


i = 0

Do While i < bundle.MessageCount - 1
    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