Chilkat Examples

ChilkatHOME.NET Core C#Android™AutoItCC#C++Chilkat2-PythonCkPythonClassic ASPDataFlexDelphi ActiveXDelphi DLLGoJavaLianjaMono C#Node.jsObjective-CPHP ActiveXPHP ExtensionPerlPowerBuilderPowerShellPureBasicRubySQL ServerSwift 2Swift 3,4,5...TclUnicode CUnicode C++VB.NETVBScriptVisual Basic 6.0Visual FoxProXojo Plugin

SQL Server Examples

Web API Categories

ASN.1
AWS KMS
AWS Misc
Amazon EC2
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Async
Azure Cloud Storage
Azure Key Vault
Azure Service Bus
Azure Table Service
Base64
Bounced Email
Box
CAdES
CSR
CSV
Certificates
Code Signing
Compression
DKIM / DomainKey
DNS
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
EBICS
ECC
Ed25519
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
GMail SMTP/IMAP/POP
Geolocation
Google APIs
Google Calendar
Google Cloud SQL
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text
HTTP

HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
MS Storage Providers
Microsoft Graph
Misc
NTLM
OAuth1
OAuth2
OIDC
Office365
OneDrive
OpenSSL
Outlook
Outlook Calendar
Outlook Contact
PDF Signatures
PEM
PFX/P12
PKCS11
POP3
PRNG
REST
REST Misc
RSA
SCP
SCard
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
ScMinidriver
SharePoint
SharePoint Online
Signing in the Cloud
Socket/SSL/TLS
Spider
Stream
Tar Archive
ULID/UUID
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(SQL Server) SendRawEmail (HTML Email with PDF Attachment)

See more Amazon SES Examples

Demonstrates how to use the SES SendRawEmail action to send an email with an attachment. Note: The total size of an SES email cannot exceed 10MB.

See SES SendRawEmail for more information.

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
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    -- Let's first prepare the email to be sent..
    DECLARE @email int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Email', @email OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @email, 'Charset', 'utf-8'
    EXEC sp_OASetProperty @email, 'Subject', 'Test email with PDF attachment.'
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, '<html><body><p>This is a test <b>HTML email with a PDF attachment</b></p></body></html>'

    -- The AddFileAttachment method returns the content-type selected based on the 
    -- file extension.   This example has no need of using the return value..
    DECLARE @contentType nvarchar(4000)
    EXEC sp_OAMethod @email, 'AddFileAttachment', @contentType OUT, 'qa_data/pdf/fishing.pdf'
    EXEC sp_OAGetProperty @email, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        RETURN
      END

    -- Add the From header, and some recipients.
    -- The From address should be an email address verified for use
    -- as a sender for your Amazon SES account.
    -- The From address will also be the Source parameter for the SES SendRawEmail request.
    EXEC sp_OASetProperty @email, 'From', 'Chilkat Software <admin@chilkatdownload.com>'

    -- Add recipients...
    -- Note: We DO NOT add BCC recipients to the email.  A BCC address should not be
    -- present in the MIME header of the email (otherwise it would not be "blind" because
    -- other recipients would be able to see it).
    -- These same addresses will be added as parameters to the SendRawEmail request.
    -- (BCC addresses are added as parameters at that time.)
    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Mr. Simulator', 'success@simulator.amazonses.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Chilkat Support', 'support@chilkatsoft.com'
    EXEC sp_OAMethod @email, 'AddCC', @success OUT, 'Some Yahoo', 'somebody@yahoo.com'

    -- Get the MIME of the email to be sent.
    DECLARE @mimeStr nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetMime', @mimeStr OUT

    -- We'll need the MIME base64 encoded for the SES REST request..
    DECLARE @crypt int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Crypt2', @crypt OUT

    DECLARE @mimeBase64 nvarchar(4000)
    EXEC sp_OAMethod @crypt, 'EncodeString', @mimeBase64 OUT, @mimeStr, 'utf-8', 'base64'

    -- OK.. our MIME email is prepared.  Now use Chilkat REST to send it..

    DECLARE @rest int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Rest', @rest OUT

    -- Connect to the Amazon AWS REST server.
    -- such as https://email.us-west-2.amazonaws.com/
    DECLARE @bTls int
    SELECT @bTls = 1
    DECLARE @port int
    SELECT @port = 443
    DECLARE @bAutoReconnect int
    SELECT @bAutoReconnect = 1
    DECLARE @success int
    EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'email.us-west-2.amazonaws.com', @port, @bTls, @bAutoReconnect

    -- Provide AWS credentials for the REST call.
    DECLARE @authAws int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.AuthAws', @authAws OUT

    EXEC sp_OASetProperty @authAws, 'AccessKey', 'AWS_ACCESS_KEY'
    EXEC sp_OASetProperty @authAws, 'SecretKey', 'AWS_SECRET_KEY'
    -- the region should match our URL above..
    EXEC sp_OASetProperty @authAws, 'Region', 'us-west-2'
    EXEC sp_OASetProperty @authAws, 'ServiceName', 'ses'

    EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws

    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Action', 'SendRawEmail'

    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'RawMessage.Data', @mimeBase64

    -- Add up to 100 TO, CC, and BCC recipients.
    -- If your SES account is still in the sandbox, you also must verify every recipient email address except for the recipients 
    -- provided by the Amazon SES mailbox simulator. (See http://docs.aws.amazon.com/ses/latest/DeveloperGuide/mailbox-simulator.html)
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Destination.ToAddresses.member.1', 'success@simulator.amazonses.com'
    -- Please do not test by sending email to Chilkat (Thank You!)
    -- Please do not test by sending email to Chilkat (Thank You!)
    -- Please do not test by sending email to Chilkat (Thank You!)
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Destination.CcAddresses.member.1', 'support@chilkatsoft.com'
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Destination.CcAddresses.member.2', 'somebody@yahoo.com'
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Destination.BccAddresses.member.1', 'somebody@gmail.com'

    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'Source', 'admin@chilkatdownload.com'

    -- Because there may be a large amount of data in the query params, use a POST
    -- where the params are sent in the body of the HTTP Request.
    DECLARE @responseXml nvarchar(4000)
    EXEC sp_OAMethod @rest, 'FullRequestFormUrlEncoded', @responseXml OUT, 'POST', '/'
    EXEC sp_OAGetProperty @rest, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @crypt
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @authAws
        RETURN
      END

    -- A successful response will have a status code equal to 200.
    EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
    IF @iTmp0 <> 200
      BEGIN

        EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
        PRINT 'response status code = ' + @iTmp0

        EXEC sp_OAGetProperty @rest, 'ResponseStatusText', @sTmp0 OUT
        PRINT 'response status text = ' + @sTmp0

        EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
        PRINT 'response header: ' + @sTmp0

        PRINT 'response body: ' + @responseXml
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @crypt
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @authAws
        RETURN
      END

    -- Examine the successful XML response.
    DECLARE @xml int
    EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Xml', @xml OUT

    EXEC sp_OAMethod @xml, 'LoadXml', @success OUT, @responseXml
    EXEC sp_OAMethod @xml, 'GetXml', @sTmp0 OUT
    PRINT @sTmp0

    -- To get the MessageId

    EXEC sp_OAMethod @xml, 'ChilkatPath', @sTmp0 OUT, 'SendEmailResult|MessageId|*'
    PRINT 'MessageId: ' + @sTmp0

    -- A sample successful response:
    -- <?xml version="1.0" encoding="utf-8" ?>
    -- <SendEmailResponse xmlns="http://ses.amazonaws.com/doc/2010-12-01/">
    --     <SendEmailResult>
    --         <MessageId>010101579081d2c1-043c693f-5a23-4c64-a8c1-66187d3725a0-000000</MessageId>
    --     </SendEmailResult>
    --     <ResponseMetadata>
    --         <RequestId>e2b5b480-8a4e-11e6-85cd-21b1f1f6d432</RequestId>
    --     </ResponseMetadata>
    -- </SendEmailResponse>

    EXEC @hr = sp_OADestroy @email
    EXEC @hr = sp_OADestroy @crypt
    EXEC @hr = sp_OADestroy @rest
    EXEC @hr = sp_OADestroy @authAws
    EXEC @hr = sp_OADestroy @xml


END
GO

 

© 2000-2024 Chilkat Software, Inc. All Rights Reserved.