Get Raw Messages Source of an Email (i.e. MIME Source)

The raw message source of an email is obtained by calling the email object's GetMime method.

Download Chilkat Email ActiveX

Download 32-bit Chilkat IMAP ActiveX (.msi)

Download All 32-bit Chilkat ActiveX Components (.zip)

Download All 64-bit Chilkat ActiveX Components (.zip)

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email2', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  For demonstration purposes, create an email
    --  so that GetMime may be called to get the raw MIME source.
    --  Email objects received from POP3 or IMAP servers behave the same.
    EXEC sp_OASetProperty @email, 'Subject', 'This is a test'
    EXEC sp_OASetProperty @email, 'Body', 'This is a test'
    EXEC sp_OASetProperty @email, 'From', 'support@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', NULL, 'Matt', 'matt@chilkatsoft.com'

    DECLARE @success int

    DECLARE @contentType nvarchar(4000)

    EXEC sp_OAMethod @email, 'AddFileAttachment', @contentType OUT, 'il1120.pdf'
    IF @contentType Is NULL 
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Call GetMime to get the raw message source.
    DECLARE @mimeSource nvarchar(4000)

    EXEC sp_OAMethod @email, 'GetMime', @mimeSource OUT


    PRINT @mimeSource
END
GO