SQL Server

Example to Add Several CC Email Recipients

See more Email Object Examples

Demonstrates how to call AddCC once per email recipient. SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'Subject', 'Test email subject'
    EXEC sp_OASetProperty @email, 'Body', 'Test email body'

    EXEC sp_OASetProperty @email, 'From', 'Test <joe@example.com>'

    --  Add a primary TO recipient
    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Elizabeth', 'elizabeth@example.com'

    --  Add 3 CC recipients.
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Jerry', 'jerry@example.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Mira', 'mira@example.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Alexander', 'alex@example.com'

    --  You can see the resultant email:

    EXEC sp_OAMethod @email, 'GetMime', @sTmp0 OUT
    PRINT @sTmp0

    --  MIME-Version: 1.0
    --  Date: Sat, 30 Oct 2021 07:48:08 -0500
    --  Message-ID: <B64DBAC9654C24AC702EA14AEC3A24C6E8480689@SLICE>
    --  Content-Type: text/plain; charset=us-ascii; format=flowed
    --  Content-Transfer-Encoding: 7bit
    --  X-Priority: 3 (Normal)
    --  Subject: Test email subject
    --  From: Test <joe@example.com>
    --  To: Elizabeth <elizabeth@example.com>
    --  Cc: Jerry <jerry@example.com>, Mira <mira@example.com>,
    --   Alexander <alex@example.com>
    --  
    --  Test email body

    EXEC @hr = sp_OADestroy @email


END
GO