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
Nodes
- DB Reader (Labs)1 ×
- DB Table Selector (Labs)1 ×
- Excel Writer1 ×
- Path to String (Variable)1 ×
- SQLite Connector (Labs)1 ×
- Show all 6 nodes