SQL Server

Get the POP3 Mailbox Message Count

Demonstrates the Chilkat MailMan.GetMailboxCount method, which returns the number of emails currently available in the POP3 mailbox, or -1 if an error occurs. It is functionally identical to CheckMail. This example configures the POP3 connection and reads the count.

Background: The message count is the number of messages sitting in the POP3 maildrop — the server-side spool that holds mail until a client downloads (and typically deletes) it. Because POP3's traditional model moves mail off the server, this count is essentially the size of the "inbox to be picked up." Chilkat auto-connects using the configured MailHost, credentials, and SSL settings if no session is open.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    --  Demonstrates the MailMan.GetMailboxCount method, which returns the number of emails
    --  currently available in the POP3 mailbox (or -1 if an error occurs).  It is functionally
    --  identical to CheckMail.

    DECLARE @mailman int
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  Configure the POP3 server connection.
    EXEC sp_OASetProperty @mailman, 'MailHost', 'pop.example.com'
    EXEC sp_OASetProperty @mailman, 'MailPort', 995
    EXEC sp_OASetProperty @mailman, 'PopSsl', 1
    EXEC sp_OASetProperty @mailman, 'PopUsername', 'user@example.com'
    EXEC sp_OASetProperty @mailman, 'PopPassword', 'myPassword'

    DECLARE @count int
    EXEC sp_OAMethod @mailman, 'GetMailboxCount', @count OUT

    PRINT 'Mailbox message count: ' + @count

    --  Note: Explicitly connecting/authenticating is optional.  Chilkat MailMan automatically
    --  connects and authenticates -- using the property settings above -- whenever a server
    --  operation requires it.  Calling the explicit connect/authenticate methods can still be
    --  helpful to determine whether a failure occurs while connecting or while authenticating.

    EXEC @hr = sp_OADestroy @mailman


END
GO