SQL Server

Set the X-Priority Header of an Email

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

--
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
    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