SendMail

Send a new email to the specified recipients.

Stored Procedure Specific Information

You can send a mail with attachments, specifying one or more file paths or the base 64 content of the attachment. To specify file paths use Attachments input, whereas for base 64 encoded content specify AttachmentContent and AttachmentName. Note that if the file location specified in the 'Attachments' input is a folder, than all the files of the first level in that folder will be sent as attachments.

EXECUTE SendMail Subject = 'Issue with CData Power BI Connector for Microsoft Exchange', Content = 'I am not being able to connect to Microsoft Exchange', Attachments = 'C:\Users\User\Desktop\logfile.txt,C:\Users\User\Desktop\TestConnectionLog.txt', ToRecipients = '[email protected]'

You can include CC and BCC recipients and send the mail. To specify one or more recipients, separate them using ','.

EXECUTE SendMail Subject = 'Issue with CData Power BI Connector for Microsoft Exchange', Content = 'I am am not being able to connect to Microsoft Exchange', ToRecipients = '[email protected]', CcRecipients = '[email protected], [email protected], [email protected]', BccRecipients = '[email protected]'

Input


Name	Type	Required	Description
Subject	String	True	The email subject.
Content	String	True	Email body content.
Attachments	String	False	The attachments. Specify the filepaths of the files you want to attach in the following format: 'filepath1,filepath2'.
AttachmentContent	String	False	The attachment content base 64 encoded.
AttachmentName	String	False	The name of the file that will be created out of the attachment content.
ToRecipients	String	True	The recipients. Specify recipients in the following format: '[email protected],[email protected]'.
CcRecipients	String	False	The Cc: recipients for the message. Specify recipients in the following format: '[email protected],[email protected]'.
BccRecipients	String	False	The Bcc: recipients for the message. Specify recipients in the following format: '[email protected],[email protected]'.