SQL Server

Convert HTML Text to an EML File

Demonstrates Mht.HtmlToEMLFile, which creates an EML MIME message from an in-memory HTML string and saves it to a file.

The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background. The EML output is a MIME email message containing the HTML page and its referenced resources, suitable for sending the page as an HTML email.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @mht int
    EXEC @hr = sp_OACreate 'Chilkat.Mht', @mht OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  The file paths are relative to the application's current working directory.  Absolute paths
    --  may also be used.  Supply the paths appropriate to your own environment.

    --  Create an EML MIME message from an in-memory HTML string and save it to a file.
    DECLARE @htmlText nvarchar(4000)
    SELECT @htmlText = '<html><head><title>Example</title></head><body><h1>Hello</h1><p>An example HTML page.</p></body></html>'
    EXEC sp_OAMethod @mht, 'HtmlToEMLFile', @success OUT, @htmlText, 'qa_output/page.eml'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mht, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mht
        RETURN
      END

    PRINT 'EML saved.'

    EXEC @hr = sp_OADestroy @mht


END
GO