Send email

When to use this Flow type

In Etlworks, it is possible to send an email notification when the Flow has been automatically executed by the Scheduler.

There is also a designated Flow type, Send Email. You can use it as part of a nested Flow when multiple Flows are combined in the pipeline, and it is possible to have it executed conditionally or in a loop.

Create Flow

Step 1. Create an outbound email Connection.

Step 2. Continue by opening the Flows window, clicking +, and typing email into the Select Flow Type box. Select the Send Email Flow type.

Step 3. Select the Outbound Email Connection created in Step 1.

Step 4. Select the Parameters tab and enter the email parameters. Most of them are optional overrides corresponding to outbound email Connection parameters:

• From: the from email address.
• To: the to email addresses.
• Cc: the cc email addresses.
• Bcc: the bcc email addresses.
• Subject: the email's subject.
• Message: the message body. You can use HTML formatting tags.
• Folder:  the name of the folder on the email server to copy the message to.
• File: the full name (including path) of the file to attach. 
• use a wildcard file name, for example *.csv, to attach multiple files.
• Script: the JavaScript or Python program that will be executed before sending the email. You can use it to set the global variables that can be used as {parameters} in the FROM, TO, SUBJECT, MESSAGE, FILE, etc., or as {tokens} in the Outbound Email Connection. You can also use it to conditionally disable the SQL Flow
• On Exception: by default any error causes a halt of execution. When ignore is selected, the errors will be ignored and execution will continue. Read how to configure the Flow to ignore all or specific exceptions.
• Exception Mask: you can specify what errors should be ignored while still halting execution for all other errors. Enter part or all of the exception string. This field only works when the Ignore On Exception option is selected.
• Execute if Error: if this option is selected, Etlworks will send the email if there is an error. It could be useful if, for example, you want to notify someone that there is a problem with running the Flow and you would like to attach a report.