SQL Server

Add Header Field to MIME Sub-Header in Email

See more Email Object Examples

Demonstrates how to add a header field to one of the attachment sub-headers in an email. SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

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

    EXEC sp_OASetProperty @email, 'Subject', 'test'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Chilkat', 'support@chilkatsoft.com'
    EXEC sp_OASetProperty @email, 'From', 'Matt <matt@example.com>'
    EXEC sp_OASetProperty @email, 'Body', 'This is a simple plain-text body.'

    EXEC sp_OAMethod @email, 'AddFileAttachment2', @success OUT, 'qa_data/1.HPM', 'application/x-hprimnet'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    -- Add a "ContentDescription: HPM/3.0" in the attachment's sub-header.
    -- The 1st attachment is at index 0.
    EXEC sp_OAMethod @email, 'AddAttachmentHeader', NULL, 0, 'Content-Description', 'HPM/3.0'

    -- Show the email MIME:
    EXEC sp_OAMethod @email, 'GetMime', @sTmp0 OUT
    PRINT @sTmp0

    -- This is the output:

    -- MIME-Version: 1.0
    -- Date: Wed, 16 Jan 2019 10:05:18 -0600
    -- Message-ID: <93B88835586270B7BE5202F84E171F29C10BA935@CHILKATSLICE>
    -- Content-Type: multipart/mixed; boundary="------------000502000000020502010608"
    -- X-Priority: 3 (Normal)
    -- Subject: test
    -- To: Chilkat <support@chilkatsoft.com>
    -- From: Matt <matt@example.com>
    -- 
    -- --------------000502000000020502010608
    -- Content-Type: text/plain; charset=us-ascii; format=flowed
    -- Content-Transfer-Encoding: 7bit
    -- 
    -- This is a simple plain-text body.
    -- --------------000502000000020502010608
    -- Content-Type: application/x-hprimnet; name="1.HPM"
    -- Content-Transfer-Encoding: base64
    -- Content-Disposition: attachment; filename="1.HPM"
    -- Content-Description: HPM/3.0
    -- 
    -- FILE_DATA_IS_HERE...
    -- 
    -- --------------000502000000020502010608--

    EXEC @hr = sp_OADestroy @email


END
GO