SendMailMessage
Sends the message to the specified recipient.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
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. |