SQL Server

Count the Replace Patterns Set on an Email

Demonstrates the read-only Chilkat Email.NumReplacePatterns property, which returns how many replacement patterns have been set via SetReplacePattern. When replacement patterns are present, the email bodies and header fields are modified by applying the search/replacement strings during the sending process. Pattern indexes are zero-based. This example sets two patterns and prints the count.

Background: This is Chilkat's built-in mail merge. You compose one email containing placeholder tokens (for example FIRST_NAME or CITY), register each token and its replacement with SetReplacePattern, and the substitutions are applied when the message is sent — letting you personalize a bulk mailing without building a separate message for every recipient.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    --  Demonstrates the read-only Email.NumReplacePatterns property.  Replace patterns are
    --  search/replacement strings (set with SetReplacePattern) that are applied to the email
    --  bodies and header fields during mail-merge sending.  Indexes are zero-based.

    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', 'Hello FIRST_NAME'
    EXEC sp_OASetProperty @email, 'Body', 'Dear FIRST_NAME, your order ships to CITY.'

    DECLARE @success int
    EXEC sp_OAMethod @email, 'SetReplacePattern', @success OUT, 'FIRST_NAME', 'John'
    EXEC sp_OAMethod @email, 'SetReplacePattern', @success OUT, 'CITY', 'Denver'


    EXEC sp_OAGetProperty @email, 'NumReplacePatterns', @iTmp0 OUT
    PRINT 'NumReplacePatterns = ' + @iTmp0

    EXEC @hr = sp_OADestroy @email


END
GO