extract content from DB and send email

This workflow shows how one can extract content from a database (SQLite in this case) and send by email.

Some notes:
- I used Mailhog (see link below), an open source local mailserver to test the workflow. This is very handy, if you don't want to use your personal email accounts for testing
- In Mailhog, it seems at first glance that you don't have an attachment. But if you download the email from Mailhog as eml file and open it (e. g. in Outlook or Thunderbird email clients) you will see that the spreadsheet is attached
- This is more or less based on a post by Ivan on the KNIME forums, also added as a link below

This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist", click on the link below to find out more or subscribe for free.

External resources

• The Data Alchemist
• Ivan's Post on the KNIME forums
• Mailhog local smtp / mailserver for testing (open source)