Chilkat • HOME • Android™ • AutoIt • C • C# • C++ • Chilkat2-Python • CkPython • Classic ASP • DataFlex • Delphi DLL • Go • Java • Node.js • Objective-C • PHP Extension • Perl • PowerBuilder • PowerShell • PureBasic • Ruby • SQL Server • Swift • Tcl • Unicode C • Unicode C++ • VB.NET • VBScript • Visual Basic 6.0 • Visual FoxPro • Xojo Plugin
(SQL Server) Email Recipients - AddTo, AddCC, AddBcc, AddMultipleTo, AddMultipleCC, AddMultipleBccThis example demonstrates the usage of AddTo, AddCC, AddBcc, AddMultipleTo, AddMultipleCC, and AddMultipleBcc.
-- 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 |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.