(Excel) Read iCloud Email Account using IMAP

Demonstrates how to set the IMAP settings for an iCloud email account and downloads the email from Inbox.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes Chilkat Imap to have been previously unlocked.
' See Unlock Imap for sample code.

Dim imap As Chilkat.Imap
Set imap = Chilkat.NewImap

' Connect to the iCloud IMAP Mail Server
imap.Ssl = True
imap.Port = 993

success = imap.Connect("imap.mail.me.com")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' The username is usually the name part of your iCloud email address 
' (for example, emilyparker, not emilyparker@icloud.com).
success = imap.Login("ICLOUD_USERNAME","ICLOUD_PASSWORD")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Select an IMAP folder/mailbox
success = imap.SelectMailbox("Inbox")
If (success <> True) Then
    Debug.Print imap.LastErrorText
    Exit Sub
End If

' Once the folder/mailbox is selected, the NumMessages property
' will contain the number of emails in the mailbox.
' Loop from 1 to NumMessages to fetch each email by sequence number.


n = imap.NumMessages

bUid = False
For i = 1 To n

    ' Download the email by sequence number.
    Set email = imap.FetchSingle(i,bUid)
    If (imap.LastMethodSuccess <> True) Then
        Debug.Print imap.LastErrorText
        Exit Sub
    End If

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

Next

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

Debug.Print "Success."

' Sample output:

' 	1: iCloud <noreply@email.apple.com>
' 	    Welcome to iCloud Mail.
' 	-
' 	2: "Chilkat Software" <support@chilkatsoft.com>
' 	    This is a test
' 	-
' 	Success.