Send Mail Task Editor (Mail Page)
Applies To: SQL Server 2016
Use the Mail page of the Send Mail Task Editor dialog box to specify recipients, message type, and priority for a message. You can also attach files to the message. The message text can be a string you provide, a file connection to a file that contains the text, or the name of a variable that contains the text.
To learn about this task, see Send Mail Task.
Select an SMTP connection manager in the list, or click <New connection…> to create a new connection manager.
Related Topics: SMTP Connection Manager
Specify the e-mail address of the sender.
Provide the e-mail addresses of the recipients, delimited by semicolons.
Specify the e-mail addresses, delimited by semicolons, of individuals who also receive copies of the message.
Specify the e-mail addresses, delimited by semicolons, of individuals who receive blind carbon copies (Bcc) copies of the message.
Provide a subject for the e-mail message.
Select the source type of the message. This property has the options listed in the following table.
|Direct input||Set the source to the message text. Selecting this value displays the dynamic option, MessageSource.|
|File connection||Set the source to the file that contains the message text. Selecting this value displays the dynamic option, MessageSource.|
|Variable||Set the source to a variable that contains the message text. Selecting this value displays the dynamic option, MessageSource.|
Set the priority of the message.
Provide the file names of attachments to the e-mail message, delimited by the pipe (|) character.
Type the message text or click the browse button (…) and then type the message in the Message source dialog box.
Select a File connection manager in the list or click <New connection…> to create a new connection manager.
Select a variable in the list or click <New variable…> to create a new variable.