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
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.7
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.