SEND.MAIL

The command will send an e-mail for each record in the FROM Data Source or a single e-mail if the Data Source FROM is not specified. The command is introduced from Perfion2022 R1.

Properties

From

Optional. Input Data Source.

If the input is a neutral Table-format the columns can be used to map fields to the e-mails.

If the input is a binary stream, the input will be attached to the e.mail.

To

Optional. Name of the Output Data Source.

The output will contain the result of the send e-mails. Besides the columns from the Input Data Source, the output will contain columns: To, Subject, Body, Cc, Bcc, Attachment, ReplyTo, SendSucceed, ErrorMessage, IgnoreError.

Parameters

@SMTP	The SMTP connection. See the below SMTP section for more info and the syntax. Lookup from a named Connection defined in Perfion Go to Administration -> Remote Queries and open a query to see available Remote Connection names: @REMOTECONNECTIONNAME=Gmail
@IgnoreError	Ignore errors when sending e-mail. If the sending failed the "SendSucceed" in the output will be False
@To	The recipients of this e-mail message. Multiple recipients can be added, separated with Comma or Semicolon
@Subject	The subject line
@Body	The message body.
@Cc	The carbon copy (CC) recipients of the e-mail message. Multiple recipients can be added, separated with Comma or Semicolon
@Bcc	The blind carbon copy (BCC) recipients of the e-mail message. Multiple recipients can be added, separated with Comma or Semicolon
@Attachment	Binary GUID's added as attachments to the e-mail. Multiple binary GUID's can be added, separated with semicolon. In the e-mail sent, the filename stored in Perfion is used.
@ReplyTo	The Reply to e-mail address

Map

From	Name of Header, as it is named from Input-source.
To	e-Mail parameters: To, Subject, Body, Cc, Bcc, Attachment and ReplyTo can be mapped from the Input source instead of using the @parameters. It is not possible to specify the same parameter eg. "To" both as a Mapping and a parameter.
Script	Any Script code to execute for this header

SMTP

Syntax:

host=<server name or ip>;port=<portnumber>;username=<username on server>;
password=<password in plaintext>;usessl=<true/false>;fromaddress=<from address>
;fromname=<from name>

Setting	Description	Default value

Setting	Description	Default value
Host	The Name of the Header as it should be called in the Output-source.	Mandatory/Not specified
Port	The Port number on the SMTP host	587
FromAddress	The displayed "From address"	Mandatory/Not specified
FromName	The displayed "From name"	Not specified
Username	Username to the login credentials	Not specified
Password	Password in plane text to the login credentials	Not specified
UseSSL	Use Secure Sockets Layer (SSL) to encrypt the connection	Default is false
UseHTML	Use HTML in the mail message body	Default is false

Example 1

Example of SEND.MAIL command setup in Actions to send mail for each image in tblProducts.

Notice that the body and attachment do not use the @parameters, so they are mapped from the input source and the feature value will show in the body and the Lifestyle image is used as an attachment.

Example 1

Example of SEND.MAIL command setup in Actions to send mail with attachment BinaryStream.

1 Properties
2 Parameters
3 Map
4 SMTP
5 Example 1
6 Example 1