(SQL Server) Set the X-Priority Header of an Email

Demonstrates how to set the X-Priority header field of an email.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- The AddHeaderField can be called to add any header field.
    -- If the header field already exists, AddHeaderField replaces it.
    DECLARE @email int
    -- Use "Chilkat_9_5_0.Email" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @email, 'AddHeaderField', NULL, 'X-Priority', '3 (Normal)'

    EXEC sp_OAMethod @email, 'AddHeaderField', NULL, 'X-Priority', '1 (High)'

    EXEC sp_OAMethod @email, 'AddHeaderField', NULL, 'X-Priority', '5 (Low)'

    -- The X-Priority value ranges from 1 to 5, with 1 being 
    -- high priority, 3 is normal, and 5 is low.
    -- You may set X-Priority to the number alone:

    EXEC sp_OAMethod @email, 'AddHeaderField', NULL, 'X-Priority', '1'

    -- Including extra text, such as (High), should not 
    -- affect how the header is interpreted.
    EXEC sp_OAMethod @email, 'AddHeaderField', NULL, 'X-Priority', '1 (High)'

    EXEC @hr = sp_OADestroy @email


END
GO