Create Email with Embedded Link

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

Download Chilkat Email ActiveX

Download 32-bit Chilkat IMAP ActiveX (.msi)

Download All 32-bit Chilkat ActiveX Components (.zip)

Download All 64-bit Chilkat ActiveX Components (.zip)

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email2', @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


END
GO