Overdue Invoices Email Notification

This component automatically sends emails to managers about invoices that require some particular action. The email body is shown below. It will be customized by the manager name, invoice ID, action item, and invoice due status as provided in the input table. The example email looks as follows:

"Dear Felix,
for the Item: IN-02.94 please take the following action: Sell to factoring

Current Due Status: 90+ Days

*This message is generated by a KNIME workflow, please do not respond to this email!*"

To enable SMTP server, for example, Gmail SMTP server, you will need to allow less secure apps under Google Account > Security > Less secure app access. Be aware that less secure apps can make your account more vulnerable. Other requirements might be needed for other mail providers.

Options

Manager's email: A column containing managers' email addresses.
Manager: A column containing managers' names.
Invoice ID: A column containing the invoice IDs.
Action: A column containing the required actions.
Due status: A column containing the due status of the invoices.
Email account credentials: Username and password for SMTP host, in other words, the credentials for the sender's email account.
SMTP Port: The port on which to connect to your SMTP server (25, 465, 587 are popular choices, but check with your mail provider).
Priority: The X-Priority flag in the mail header. Standard email clients display the email in different styles depending on the flag.
Connection Security: Choose a method for secure communication with your SMTP Host. SSL or STARTTLS will use these methods respectively, while None will send your data unencrypted over the network.
From (your email): The sender address. It serves as a sender address as well as a return address for the message (only if supported by your SMTP host).
SMTP Host: The domain name of your SMTP server. SMTP host must support sending emails from another application. Some example SMTP hosts can be found here (the list isn't exhaustive): https://www.serversmtp.com/smtp-server-address/. Otherwise check with your mail provider.

Input Ports

: The input data table containing at least 5 string columns for the manager name and email address, invoice ID and due status, and the required action.

Output Ports

This node has no output ports

Overdue Invoices Email Notification

Options

Input Ports

Output Ports

Nodes

Extensions

Links

Download