(SQL Server) Email Recipients - AddTo, AddCC, AddBcc, AddMultipleTo, AddMultipleCC, AddMultipleBcc

This example demonstrates the usage of AddTo, AddCC, AddBcc, AddMultipleTo, AddMultipleCC, and AddMultipleBcc.

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)
    -- An email can have any number of To, CC, or Bcc recipients.
    DECLARE @email int
    -- Use "Chilkat_9_5_0.Email" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- One recipient per AddTo, AddCC, or AddBcc call may be added:
    -- The 1st argument is the friendly name, the 2nd argument
    -- is the email address.
    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Chilkat Support', 'support@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Person 1', 'person1@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Person 2', 'person2@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Person 3', 'person3@chilkatsoft.com'

    -- This email now has 4 "To" recipients.

    -- Now add some CC recipients:
    -- Note: the friendly name may be empty if desired...
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Person 4', 'person4@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, '', 'person5@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Person 6', 'person6@chilkatsoft.com'

    -- Now the email has 7 total recipients (3 "To" and 4 "CC")

    -- Now add some Bcc recipients:
    EXEC sp_OAMethod @email, 'AddBcc', @success OUT, '', 'person7@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddBcc', @success OUT, 'Person 8', 'person8@chilkatsoft.com'

    -- Clear all recipients via ClearTo, ClearCC, and ClearBcc:
    EXEC sp_OAMethod @email, 'ClearTo', NULL
    EXEC sp_OAMethod @email, 'ClearCC', NULL
    EXEC sp_OAMethod @email, 'ClearBcc', NULL

    -- The email is now back to 0 recipients...

    -- Add recipients just as before, but this time use
    -- AddMultipleTo, AddMultipleCC, and AddMultipleBcc.
    -- These methods accept a comma-separated list of 
    -- email addresses.  For example:

    EXEC sp_OAMethod @email, 'AddMultipleTo', @success OUT, 'Chilkat Support <support@chilkatsoft.com>, Person 1 <person1@chilkatsoft.com>, Person 2 <person2@chilkatsoft.com>, Person 3 <person3@chilkatsoft.com>'

    EXEC sp_OAMethod @email, 'AddMultipleCC', @success OUT, 'Person 4 <person4@chilkatsoft.com>, person5@chilkatsoft.com, Person 6 <person6@chilkatsoft.com>'

    EXEC sp_OAMethod @email, 'AddMultipleBcc', @success OUT, 'person7@chilkatsoft.com, Person 8 <person8@chilkatsoft.com>'

    EXEC sp_OASetProperty @email, 'Body', 'this is a test'
    EXEC sp_OASetProperty @email, 'Subject', 'this is a test'

    -- Display the MIME:
    EXEC sp_OAMethod @email, 'GetMime', @sTmp0 OUT
    PRINT @sTmp0

    EXEC @hr = sp_OADestroy @email


END
GO