SQL Server

Add a Plain-Text Alternative Body to an Email

Demonstrates the Chilkat Email.AddPlainTextAlternativeBody method, which adds a plain-text alternative body. Combined with an HTML body, it produces a multipart/alternative email that carries both representations. This example sets an HTML body, adds a plain-text alternative, and prints the alternative count.

Background: This is the companion to AddHtmlAlternativeBody. A polished email provides both an HTML body (for rich display) and a plain-text fallback, and the receiving client picks whichever it prefers. Including a real plain-text alternative — rather than letting the HTML stand alone — improves accessibility, helps with spam scoring, and guarantees the message is readable in text-only environments.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    --  Demonstrates the AddPlainTextAlternativeBody method, which adds a plain-text alternative
    --  body.  Combined with an HTML body, this produces a multipart/alternative email offering
    --  both representations of the same content.

    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', 'HTML with a plain-text alternative'

    --  Set an HTML body.
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, '<html><body><b>This is the HTML version.</b></body></html>'

    --  Add a plain-text alternative.
    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddPlainTextAlternativeBody', @success OUT, 'This is the plain-text version.'


    EXEC sp_OAGetProperty @email, 'NumAlternatives', @iTmp0 OUT
    PRINT 'NumAlternatives = ' + @iTmp0

    EXEC @hr = sp_OADestroy @email


END
GO