I tend to drop whatever I need to audit from the ETL process into a table, the use a BI tool (in my case, SSRS or Cognos) to produce and send a report

That said, I was aware but had never really played around with e-mailing with formatting

Just used the ideas presented here (initial plus some of the discussed alternatives) to produce a useful report that runs part way through my ETL build

Thanks