Step 1. Create an Outbound Email Connection.
Step 2. Continue by opening the
Flows window, clicking
+ , and typing
send 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.
Header: an optional header that will be added before the message body.
Footer: an optional footer that will be added after the message body.
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.
On Exception: by default, any error causes a halt of execution. When
Ignoreis 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 Exceptionoption 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 you want to notify someone that there is a problem with running the Flow and you would like to attach a report.
Extract and transform data, then send it to the configurable email address
An Outbound Email connection can be used as a destination in a source-to-destination transformation. The flow will extract data from the source, transform it and send it in the email to the configurable email address(es).
Step 1. Create an Outbound Email Connection, which will be used as the destination.
Step 2. Create source connection.
Step 3. Start creating a Flow in the
Flows window by clicking
+ and selecting any Flow type where the source is a database, file, web service, or social website and the destination is a file.
Step 4. Modify the Flow by selecting the Connection created in Step 2 as the source (
FROM), and the Connection created in Step 1 as the destination (
Step 5. Add
Mapping and modify
Parameters, if needed.
Send notifications by email
In Etlworks, it is possible to send an email notification when the Flow has been automatically executed by the scheduler.
It is also possible to send an email notification for any event triggered by Webhook. Read more.