This tutorial shows how to send one email message per Excel file row in Advanced ETL Processor. Use it when each spreadsheet row needs its own message, because nothing says automation like a workbook quietly becoming a mailroom.
What You Will Learn
- Read message data from Excel sheets, tables, or ranges.
- Map each Excel row into an outgoing email message.
- Configure the SMTP Writer connection for email delivery.
- Test the workflow before sending messages from production data.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Excel Reader and SMTP Writer Docs
This tutorial reads rows from Excel and sends one email message per row through the SMTP Writer. In practice, test with a small file first. A bad email loop can make friends with your mail server very quickly.
The supporting Excel Reader documentation covers reader properties, the ignore format option, and working with Excel tables and ranges.
The SMTP Writer documentation covers how SMTP sending works and SMTP Writer properties.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.