SendMailMessage
Sends a message to the specified recipient.
Stored Procedure Specific Information
Send an email by using this procedure.
Example on how to include attachments:
By using JSON aggregates
{
"Attachments": [{"fileName": "filename", "data": "base64Encoded attachment content"}]
}
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @Attachments = "json aggregate"
By using temporary tables:
INSERT INTO Attachments#TEMP (FileName, Data) VALUES ('MyFile.txt', "base64Encoded data")
INSERT INTO Attachments#TEMP (FileName, Data) VALUES ('C:\\MyDirectory\\MyFile.extensio', "")
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @Attachments = "Attachments#TEMP"
The following scenarios still wok but are deprecated and will be removed in future releases.
Example to attach only one file:
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'C:\\MyDirectory\\MyFile.extension'
Example to attach all files of the first level on a directory:
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'C:\\MyDirectory'
Example to attach a combination of multiple files and folders:
INSERT INTO attach#TEMP (AttachmentPath) VALUES ('C:\\MyDirectory\\MyFile.extension')
INSERT INTO attach#TEMP (AttachmentPath) VALUES ('C:\\MyDirectory2')
EXECUTE SendMailMessage @Subject = 'subject', @To = 'email', @From = 'sender_email', @CC = 'email', @BCC = 'email', @Content = 'content', @AttachmentPath = 'attach#TEMP'
Example to include multiple email recipients:
EXECUTE SendMailMessage @Subject = 'subject', @To = '[email protected],[email protected]', @From = 'sender_email', @CC = '[email protected],[email protected]', @BCC = '[email protected],[email protected]', @Content = 'content'
Input
| Name | Type | Required | Description |
| Subject | String | True | The subject of the mail message. |
| To | String | True | The email address(es) of the recipient(s). |
| From | String | False | The email address of the sender. |
| CC | String | False | CCed recipient(s). |
| BCC | String | False | BCCed recipient(s). |
| Content | String | True | The message body. |
| AttachmentPath | String | False | The attachment file names (with the path if reading from a file) to include in the message. |
Result Set Columns
| Name | Type | Description |
| Id | String | The Id for the message as returned by the server. |