(SQL Server) SES Send Email using SMTP on Port 465 (TLS)

See more Amazon SES Examples

Demonstrates how to send SES email using the SMTP protocol with an implicit TLS connection on port 465.

For more information, see https://docs.aws.amazon.com/ses/latest/dg/send-email-smtp-client-command-line.html

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @mailman int
    -- Use "Chilkat_9_5_0.MailMan" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Use your SMTP endpoint from your Amazon SES --> SMTP Settings
    EXEC sp_OASetProperty @mailman, 'SmtpHost', 'email-smtp.us-west-2.amazonaws.com'

    -- You need Amazon SES SMTP credentials to access the SES SMTP interface.
    -- The credentials that you use to send email through the SES SMTP interface are unique to each AWS Region. 
    -- If you use the SES SMTP interface to send email in more than one Region, 
    -- you must generate a set of SMTP credentials for each Region that you plan to use.
    -- See SES SMTP Credentials

    -- Use your SMTP username and SMTP password for the SMTP credentials you created..
    EXEC sp_OASetProperty @mailman, 'SmtpUsername', 'AKIA54PBFR4HUHGCIZDS'
    EXEC sp_OASetProperty @mailman, 'SmtpPassword', 'BrVsadsAULqtHIaEBqx8Xsug073cGYc0PXBYcj17w4OW'

    EXEC sp_OASetProperty @mailman, 'SmtpSsl', 1
    EXEC sp_OASetProperty @mailman, 'SmtpPort', 465

    -- Create a new email object
    DECLARE @email int
    -- Use "Chilkat_9_5_0.Email" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT

    EXEC sp_OASetProperty @email, 'Subject', 'This is a test'
    EXEC sp_OASetProperty @email, 'Body', 'This is a test'
    EXEC sp_OASetProperty @email, 'From', 'Chilkat Support <support@chilkatsoft.com>'
    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Chilkat Admin', 'admin@chilkatsoft.com'

    EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email
    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

    EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
    IF @success <> 1
      BEGIN

        PRINT 'Connection to SMTP server not closed cleanly.'
      END


    PRINT 'Mail Sent!'

    EXEC @hr = sp_OADestroy @mailman
    EXEC @hr = sp_OADestroy @email


END
GO