(Excel) POP3 Verify Signed (S/MIME) Email

Demonstrates how to download and verify digitally signed S/MIME email.

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.

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 sa = mailman.GetUidls()
If (mailman.LastMethodSuccess = False) Then
    Debug.Print mailman.LastErrorText
    Exit Sub
End If


i = 0
Do While i < sa.Count

    uidl = sa.GetString(i)

    Set email = mailman.FetchEmail(uidl)
    If (mailman.LastMethodSuccess = False) Then
        Debug.Print mailman.LastErrorText

        Exit Sub
    End If

    Debug.Print email.From
    Debug.Print email.Subject

    ' The security layers of signed and/or encrypted emails
    ' are automatically "unwrapped" when loaded into
    ' a Chilkat email object.
    ' An application only needs to check to see if an email
    ' was received signed or encrypted, and then examine
    ' the success/failure.  For example:
    If (email.ReceivedSigned = True) Then

        Debug.Print "This email was signed."

        ' Check to see if the signatures were verified.
        If (email.SignaturesValid = True) Then
            Debug.Print "Digital signature(s) verified."
            Debug.Print "Signer: "; email.SignedBy

            ' The certificate used for signing may be obtained
            ' by calling email.GetSignedByCert.

            Set cert = email.GetSignedByCert()
            If (email.LastMethodSuccess = False) Then
                Debug.Print "Failed to get signing certificate object."
            Else
                Debug.Print "Signing cert: "; cert.SubjectCN

            End If

        Else
            Debug.Print "Digital signature verification failed."
        End If

    End If

    i = i + 1
Loop

success = mailman.Pop3EndSession()