Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Delphi ActiveXDelphi DLLVisual FoxProJavaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerShellPythonRubySQL ServerUnicode CUnicode C++Visual Basic 6.0VB.NETVBScript

SQL Server Examples

Certificates
Email Object
Encryption
FTP
HTML-to-XML/Text
Gzip
HTTP
IMAP
MHT / HTML Email
PFX/P12
Java KeyStore (JKS)
POP3
RSA Encryption
MIME
SMTP
Socket/SSL/TLS
SSH Key
SSH
SFTP
Tar Archive
XML
XMP
Zip

More Examples...
Amazon S3
Bounced Email
CSV
Diffie-Hellman
DKIM / DomainKey
NTLM

 

 

 

 

 

 

 

(SQL Server) Embed Image in HTML Email

Demonstrates how to create and send an HTML email with an embedded image.

Chilkat ActiveX Downloads

ActiveX for 32-bit and 64-bit Windows

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  The mailman object is used for sending and receiving email.
    -- This sp_OACreate statement uses the new single-DLL ActiveX for v9.5.0
    DECLARE @mailman int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.MailMan', @mailman OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  Any string argument automatically begins the 30-day trial.
    DECLARE @success int

    EXEC sp_OAMethod @mailman, 'UnlockComponent', @success OUT, '30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mailman
        RETURN
      END

    --  Set the SMTP server.
    EXEC sp_OASetProperty @mailman, 'SmtpHost', 'smtp.comcast.net'

    --  Create a new email object
    -- This sp_OACreate statement uses the new single-DLL ActiveX for v9.5.0
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        EXEC @hr = sp_OADestroy @mailman
        RETURN
    END

    --  Add an embedded image to the HTML email.
    DECLARE @fileOnDisk nvarchar(4000)

    SELECT @fileOnDisk = 'images/dude2.gif'
    DECLARE @filePathInHtml nvarchar(4000)

    SELECT @filePathInHtml = 'something/dudeAbc.gif'

    --  Embed the GIF image in the email.
    EXEC sp_OAMethod @email, 'AddRelatedFile2', @success OUT, @fileOnDisk, @filePathInHtml
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mailman
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    --  The src attribute for the image tag is set to the filePathInHtml:
    DECLARE @htmlBody nvarchar(4000)

    SELECT @htmlBody = '<html><body>Embedded Image:<br><img src="something/dudeAbc.gif"></body></html>'

    --  Set the basic email stuff: HTML body, subject, "from", "to"
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, @htmlBody
    EXEC sp_OASetProperty @email, 'Subject', 'SQL Server HTML email with an embedded image.'
    EXEC sp_OAMethod @email, 'AddTo', NULL, 'Admin', 'admin@chilkatsoft.com'
    EXEC sp_OASetProperty @email, 'From', 'Chilkat Support <support@chilkatsoft.com>'

    EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
      END
    ELSE
      BEGIN
        PRINT 'Mail Sent!'
      END
    EXEC @hr = sp_OADestroy @mailman
    EXEC @hr = sp_OADestroy @email


END
GO

 

© 2000-2014 Chilkat Software, Inc. All Rights Reserved.