JDBC Driver for Email

Build 22.0.8462

SendMailMessage

Sends the message to the specified recipient.

Note: This procedure makes use of indexed parameters. These input parameters are denoted with a '#' character at the end of their names.

Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. Input multiple instances of an indexed parameter like this:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

Input

Name Type Accepts Input Streams Description
To String False The semicolon-separated list of names and email addresses of the recipients.
Subject String False The subject of the mail message.
From String False The email address of the sender.
MessageBody String False The message body.
CC String False The semicolon-separated list of names and email addresses of the CCed recipients.
BCC String False The semicolon-separated list of names and email addresses of the BCCed recipients.
Attachment# String False Semicolon-separated list of the attachment file names (with path if reading from a file) included in the message.
AttachmentData# String False Semicolon-separated list of the base-64-encoded attachment data included in the message. (You must still specify the filename in Attachments.)
AttachmentContent String True The content as InputStream to be uploaded.
InlineImage# String False Semicolon-separated list of the inline image identifiers (cids) to be included in the message.
InlineImageData# String False Semicolon-separated list of the base-64-encoded image data to be included in the message.
InlineImageContent String True The content as InputStream to be uploaded.
IsHTML String False Whether the email is HTML or plain text.

The default value is TRUE.

Importance String False Importance of the mail message.

The allowed values are UNSPECIFIED, LOW, NORMAL, HIGH.

The default value is UNSPECIFIED.

Priority String False Priority of the mail message.

The allowed values are UNSPECIFIED, NONURGENT, URGENT, NORMAL.

The default value is UNSPECIFIED.

Sensitivity String False Sensitivity of the mail message.

The allowed values are UNSPECIFIED, PERSONAL, PRIVATE, COMPANYCONFIDENTIAL.

The default value is UNSPECIFIED.

DeliveryNotification String False Email address to send a delivery notification to.
ReadReceipt String False Email address to send a read receipt to.
Charset String False The character set to use in the message.

The default value is UTF-8.

Result Set Columns

Name Type Description
MessageId String The Id for the message as returned by the server.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462