ADO.NET Provider for Email

Build 21.0.7930

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 Description
To String The semicolon-separated list of names and email addresses of the recipients.
Subject String The subject of the mail message.
From String The email address of the sender.
MessageBody String The message body.
CC String The semicolon-separated list of names and email addresses of the CCed recipients.
BCC String The semicolon-separated list of names and email addresses of the BCCed recipients.
Attachment# String Semicolon-separated list of the attachment file names (with path if reading from a file) included in the message.
AttachmentData# String Semicolon-separated list of the base-64-encoded attachment data included in the message. (You must still specify the filename in Attachments.)
InlineImage# String Semicolon-separated list of the inline image identifiers (cids) to be included in the message.
InlineImageData# String Semicolon-separated list of the base-64-encoded image data to be included in the message.
IsHTML String Whether the email is HTML or plain text.

The default value is TRUE.

Importance String Importance of the mail message.

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

The default value is UNSPECIFIED.

Priority String Priority of the mail message.

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

The default value is UNSPECIFIED.

Sensitivity String Sensitivity of the mail message.

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

The default value is UNSPECIFIED.

DeliveryNotification String Email address to send a delivery notification to.
ReadReceipt String Email address to send a read receipt to.
Charset String 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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930