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

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    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