SQL Server

Fetch a POP3 Message's Raw MIME by Message Number

Demonstrates the Chilkat MailMan.FetchMimeByMsgnumBd method, which retrieves an email by POP3 message number and stores the raw MIME source bytes in a BinData. Chilkat clears the BinData before downloading. This example fetches message number 1's MIME into a BinData.

Background: This is the message-number variant of FetchMimeBd. It grabs the untouched MIME bytes of a message identified by its 1-based session position — handy when iterating a mailbox by number and archiving or forwarding each message's exact source. Keep in mind message numbers are only valid within the current session, so for stable identification across sessions prefer the UIDL-based FetchMimeBd.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Demonstrates the MailMan.FetchMimeByMsgnumBd method, which retrieves an email by POP3
    --  message number and stores the raw MIME source bytes in a BinData.  Chilkat clears the
    --  BinData before downloading.

    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'

    --  Fetch the raw MIME of message number 1 into a BinData.
    DECLARE @bdMime int
    EXEC @hr = sp_OACreate 'Chilkat.BinData', @bdMime OUT

    EXEC sp_OAMethod @mailman, 'FetchMimeByMsgnumBd', @success OUT, 1, @bdMime
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @bdMime
        RETURN
      END


    EXEC sp_OAGetProperty @bdMime, 'NumBytes', @iTmp0 OUT
    PRINT 'MIME size (bytes) = ' + @iTmp0

    --  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
    EXEC @hr = sp_OADestroy @bdMime


END
GO