Send Report by Email

<p>This workflow showcases the "Email Sender (Labs)" node in conjunction with the "Email Reader (Labs)" and "Email Connector (Labs)" nodes. It aims to access all attachments from the email inbox, read them, and send a report embedded in an email within the KNIME Analytics Platform.</p><p>You can easily download and run the workflow within your KNIME installation. For optimal performance, we recommend using the latest version of the KNIME Analytics Platform.</p><p>To execute the workflow, you don't have to provide email server details such as address, port, or user login credentials. The "Email Inbox Setup" component sets up a self-contained mail server. It includes four folders and ten simulated emails with counterfeit attachments ready for use. For more information, refer to the component description.</p><p>Check external resources to connect to your ISP email account using the IMAP protocol (e.g., Gmail or Outlook) via the Email Connector (Labs) node.</p><p></p><p>Workflow Steps</p><ol><li><p><strong>Email Connector Configuration</strong></p><ul><li><p>The "Email Connector (Labs)" node does not require additional information. It is configured to read (from User2's Inbox) and send (to User3) email. All the node configuration parameters are controlled via flow variables from the upstream component.</p></li></ul></li><li><p><strong>Reading Emails and Attachments</strong></p><ul><li><p>Use the "Email Reader (Labs)" node to read emails from the inbox. Since the other folders are empty, only focus on this particular folder. By clicking "Show advanced settings," check the "Output attachments table" option, which extracts all the attachments from the emails. A second table output port will appear.</p></li></ul></li><li><p><strong>Writing Attachments to Temporary Folder</strong></p><ul><li><p>After extracting the attachments as binary objects, utilize the "Binary Objects to Files" node to write them into a temporary folder created using the "Create Temp Folder" within the workflow data area. It is essential to use the column "File name" as the new file names, including the original file names and their respective file extensions.</p></li></ul></li><li><p><strong>Reading and Processing Excel Files</strong></p><ul><li><p>Read all file attachments from the recently created temporary folder using the "Excel Reader" node. Since the files have the same structure, only one node is needed to accomplish the task.</p></li></ul></li><li><p><strong>Creating the Report</strong></p><ul><li><p>Pass the data into a component, which creates a pie chart and a table summarizing and highlighting the input data. Flag the option "Enable reporting" inside the component view layout. For more information about the reporting extension, follow the link in the External Resources section.</p></li></ul></li><li><p><strong>Sending the Email with the Report</strong></p><ul><li><p>Connect the "Email Sender (Labs)" node and the component report output port to the Email Connector. Configure the node to send the email to User3. The report will be embedded in the email.</p></li></ul></li></ol>