Email Templates

About

Email Templates provide a library of reusable email messages that can be used by Automation Packages and other processes.

Instead of creating the same email content repeatedly, you can define a template once and reuse it whenever an email needs to be sent. Templates can also include variables, allowing the message content to be populated dynamically during execution.

For example, an Automation Package can use an Email Template to notify an administrator when execution fails and include information about the failure.

Automated Notifications

Email Templates are particularly useful for sending automatic notifications when specific events occur, such as:

  • Package execution failures
  • Data validation errors
  • Transformation results
  • Successful completion of a process
  • Other events requiring user or administrator attention

Variables can be used to insert information generated during execution, such as package names, file names, error messages, or execution log details.

For example:

Package execution has failed. Please find the execution log attached.

Key Benefits

  • Reusable — Create an email template once and use it in multiple Automation Packages.
  • Dynamic Content — Use variables to include information generated during execution.
  • Immediate Notifications — Send emails as soon as an event occurs.
  • Consistent Communication — Ensure that automated notifications use a consistent format and contain the required information.
  • Easy Maintenance — Update the template in one place instead of modifying the same email text in multiple packages.

Creating New Template

Email Templates

Template Example

Email Templates

Using Variables

The example above demonstrates how variables can be included within an Email Template. Before the email is sent, these variables are replaced with their actual values generated during package execution or when a specific event occurs.

This allows a single template to be reused while dynamically including information relevant to each execution.

Use Cases

Email Templates can be used for a variety of automation and business requirements, including:

  • Reporting incidents — Notify administrators or users when errors or unexpected events occur.
  • Process notifications — Inform users when a process starts, completes, or fails.
  • Sharing results — Automatically distribute transformation, validation, or processing results.
  • Troubleshooting — Send error details, execution information, or log files to help diagnose problems.

Using Email Templates helps automate communication, ensures consistent notifications, and keeps users informed about important events during package execution.

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on August 30, 2025 • 2 min read • 406 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License