Objectives

To extend the previous exercise do the following:

• retrieve an email request

• re-use the transformation map iiiTUTMAP02 to produce a CSV file extract from the Personnel File using information from the email request

• To send an email response with the CSV file as an attachment

The email subject line will contain a department code, which will be used by the transform (Employee file to CSV file) to create a CSV file of employees in the department.

This type of processing sequence could handle many inquiries via email—for example, a product inquiry to return price, stock availability or specification information.

This tutorial requires two email addresses:

• Send a request from your own email account, with the subject line containing a department code

• Send the request to another email address. The processing sequence will use the POP3_MAILSINGLE activity to retrieve and delete all emails from this email account's inbox. You will probably need to set up this second email account.

Retrieve from your own email account. The MAIL_RECEIVE activity will retrieve a single email message from the inbox. You will need to send a request to this email account.

Steps

To meet these objectives you will complete the following:

• Step 1. Review Folders and Settings

• Step 2. Create POP3 Email Configuration

• Step 3. Create SMTP Mail Details

• Step 4. Define iiiTUTSEQ06 Processing Sequence

• Summary

Before You Begin

• Before completing this tutorial, you should have completed all the preceding tutorials.