SendMailMessage
Sends the message specified 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 | Required | Description |
| To | String | True | A semicolon-separated list of names and email addresses of the recipients. |
| Subject | String | True | The subject of the mail message. |
| From | String | False | The email address of the sender. |
| MessageBody | String | True | The message body. |
| CC | String | False | A semicolon-separated list of names and email addresses of the CCed recipients. |
| BCC | String | False | A semicolon-separated list of names and email addresses of the BCCed recipients. |
| Attachment# | String | False | A semicolon-separated list of the attachment file names (with the path if reading from a file) included in the message. |
| AttachmentData# | String | False | A semicolon-separated list of the base-64-encoded attachment data included in the message. To use this field, you must also specify the file name in Attachments. |
| IsHTML | String | False | Whether the email is HTML or plain text.
The default value is TRUE. |
| Importance | String | False | The importance of the mail message.
The allowed values are UNSPECIFIED, LOW, NORMAL, HIGH. The default value is UNSPECIFIED. |
| Priority | String | False | The priority of the mail message.
The allowed values are UNSPECIFIED, NONURGENT, URGENT, NORMAL. The default value is UNSPECIFIED. |
| Sensitivity | String | False | The sensitivity of the mail message.
The allowed values are UNSPECIFIED, PERSONAL, PRIVATE, COMPANYCONFIDENTIAL. The default value is UNSPECIFIED. |
| DeliveryNotification | String | False | The email address to send a delivery notification to. |
| ReadReceipt | String | False | The 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. |