Send Mail Task

The Other Activities tab contains the Send Mail task that can be dragged to the chart area when the Edit mode is on.

The task configuration parameters are:

• table. the field is mandatory and contains the name of the table from which the system will read the information on the emails to be sent.

The table must contains the following columns:

• "OID": represents a unique ID of the single row of string type. The data type must be VARCHAR(36).
• "DATA_INVIO": date from which the email can be sent. If set to null, the email can be sent immediately. The data type must be TIMESTAMP or an equivalent type.
• "DESTINATARI_TO", "DESTINATARI_CC", "DESTINATARI_BCC": recipients of the email. These can be either email addresses or user names. To enter multiple recipients, use the comma as a separator. The data type must be VARCHAR(MAX) or an equivalent type.
• "OGGETTO": subject of the email that will be sent. The data type must be VARCHAR(MAX) or an equivalent type.
• "FLAG_INVIO": normally it is 0 and turns into 1 after the email is sent. The system ignores all rows where this flag is 1. The data type must be SMALLINT or an equivalent type.
• "MESSAGGIO_HTML": if it is 1, the "MESSAGGIO" field is considered as HTML. The data type must be SMALLINT or an equivalent type.
• "MESSAGGIO": message of the email. The data type must be VARCHAR(MAX) or an equivalent type.