SQL Server

Set the X-Mailer Header of an Email

Demonstrates the Chilkat Email.Mailer property, which identifies the email software that sent the email. It corresponds to the MIME X-Mailer header. This example sets the mailer string and shows it in the generated MIME.

Background: X-Mailer is an optional, informational header — the X- prefix marks it as non-standard — that names the program used to compose or send the message. Mail servers do not require it and it has no effect on delivery; it is mainly useful for diagnostics and analytics. Because it is self-reported, it is trivially spoofable and should never be relied on for security decisions.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  Demonstrates the Email.Mailer property, which identifies the email software
    --  that sent the email.  This corresponds to the MIME X-Mailer header.

    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, 'Mailer', 'My Custom Mailer 1.0'


    EXEC sp_OAGetProperty @email, 'Mailer', @sTmp0 OUT
    PRINT 'Mailer = ' + @sTmp0

    --  The X-Mailer header appears in the generated MIME.
    EXEC sp_OAMethod @email, 'GetMime', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @email


END
GO