EndPoint Send Mail

Name

send_mail

Sends an email message. [API reference]

Parameter	Label	Required	Options	Description
UserId	User ID or Email	YES		The Microsoft Mail user ID GUID or email address for the account to read messages from. (Examples: '4ff54a77-9c09-4274-958f-83bdc0a53900' or 'first.last@domain.com')

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
Response	`DT_WSTR`	`nvarchar(255)`	255	`False`

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Subject	`DT_WSTR`	`nvarchar(250)`	250	`False`
BodyContentType	`DT_WSTR`	`nvarchar(8)`	8	`False`
BodyContent	`DT_NTEXT`	`nvarchar(MAX)`		`False`
ToRecipients	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
CcRecipients	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
BccRecipients	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
InternetMessageHeaders	`DT_WSTR`	`nvarchar(4000)`	4000	`True`
Attachments	`DT_NTEXT`	`nvarchar(MAX)`		`True`
Importance	`DT_WSTR`	`nvarchar(10)`	10	`False`
IsDeliveryReceiptRequested	`DT_BOOL`	`bit`		`False`
IsReadReceiptRequested	`DT_BOOL`	`bit`		`False`
SaveToSentItems	`DT_BOOL`	`bit`		`False`

Required columns that you need to supply are bolded.

Use Outlook Mail (Office 365) Connector in API Source component to read data or in API Destination component to read/write data:

This EndPoint belongs to MyMessages table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Outlook Mail (Office 365)

MyMessages

Insert