Send emails and attachments

Send emails

Send Email is the designated Flow type. 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.

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 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 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 (TO).

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.