Email Recipients - AddTo, AddCC, AddBcc, AddMultipleTo, AddMultipleCC, AddMultipleBcc

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

Download Chilkat Email ActiveX for POP3 / SMTP

Download Chilkat IMAP ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    --  An email can have any number of To, CC, or Bcc recipients.
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat.Email2', @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.
    EXEC sp_OAMethod @email, 'AddTo', NULL, 'Chilkat Support', 'support@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', NULL, 'Person 1', 'person1@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', NULL, 'Person 2', 'person2@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddTo', NULL, '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', NULL, 'Person 4', 'person4@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddCC', NULL, '', 'person5@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddCC', NULL, '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', NULL, '', 'person7@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddBcc', NULL, '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', NULL, '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', NULL, 'Person 4 <person4@chilkatsoft.com>, person5@chilkatsoft.com, Person 6 <person6@chilkatsoft.com>'

    EXEC sp_OAMethod @email, 'AddMultipleBcc', NULL, '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
END
GO