SQL Server

Create Email with Embedded Link

Creating an email with an embedded link (HTML hyperlink).

Chilkat SQL Server Downloads

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 @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- To create an email with an embedded link, use HTML:
    DECLARE @html nvarchar(4000)
    SELECT @html = '<html><body><p>Click here for more information: <a href="http://www.chilkatsoft.com/">Chilkat Software</a></body></html>'

    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, @html

    -- Continue building the email by adding the subject, recipients, etc...

    DECLARE @mime nvarchar(4000)

    EXEC sp_OAMethod @email, 'GetMime', @mime OUT

    PRINT @mime

    EXEC @hr = sp_OADestroy @email


END
GO