Automated Email Reminders on Unpaid Invoices

Automated Email Reminders on Unpaid Invoices

Hello, I need to setup a schedule for automated emails to all billing contacts on unpaid Invoices. I believe this requires a schedule to be setup based upon a function, and I'm looking for help setting up this function. There are two parts I need help with in the Deluge editor:
  1. Sending email To the email of all contacts who are attached to Invoices with a status of either "Unpaid" or "Paid in Part" and a "Due Date" after the current date. Screenshot of how these contacts are attached to Invoices below.
  2. Looking up fields from the Invoice record(s) to use in the email template; for example the "status" field.
Screenshot of how contacts are attached to Invoices below.