We need to set E-mail notification for an existing transaction when a step failed or getting error message.
Have you tired leveraging an alert with email notification as the action?
These may help:
Create an alert for WPM when a transaction is down - SolarWinds Worldwide, LLC. Help and Support
Include a screenshot in an email alert for a failed transaction step - SolarWinds Worldwide, LLC. Help and Support
Retrieving data ...