Building a task which triggers when an email is received

This example will create a task which triggers when an email matching certain criteria is received. The task will extract key information from the email, query a database, format the information returned as text and email a user derived from the information on the business database.

This task is made up of 5 steps

SMTP 1(1)

Step NameToolWhat it does
Email ReceivedEvent: Email Trigger (SMTP)Filters the content of incoming and outgoing mail sent via a virtual SMTP Mail Server.

Setting up an SMTP event trigger step

Extract Product InformationGeneral: Parse TextExtracts text data from a variable which has been placed in a step. The data is then mapped to other variables for use in further steps.

Extracting text information from an email using the Parse Text

Retrieve InformationInput: Database Query (ODBC)Reads the database of a business system to find details to include in the alert. Variables are consumed from the previous step to create a query recordset.

Querying a database

Format InformationFormat: Format As TextTakes the results from the previous step and lays them out in a way that can be read.

Formatting Plain Text

Send EmailOutput: Send Email (SMTP)Sends an email containing the formatted information

Sending an email

To read about designing other tasks see

Task Design

Related Articles

Setting up an Email Trigger (SMTP) step

Introduction The Email Trigger (SMTP) is used to trigger a task based on the contents of incoming or outgoing mail sent via a virtual SMTP email server. When an email is received it is compared against a number of filters created within the tool,…

Read More

Extracting text from an email using the Parse Text Tool

This article will show how specific text data from an email can be extracted for use in a database query. This is achieved by using variables and a General tool called Parse Text. By using rules and parameters this tool can extract specific text…

Read More