JIRA Script to email

Job ID: 31285758

Budget: $30 – $250 AUD

Need a script to email clients and update them about their order every Monday morning at "8 am Melbourne time":
in Project "MyOrders" -> find all issues with "Status" != "Closed" -> If "SEND Email" filed radio button = "YES" -> compose an email including "PO Number" and "DUE DATE" -> Send email using a custom email address to "Customer Email".
The emails need to be sent via our office 365 managed outlook email.
We have Scriptrunner available on our system. Please advise if any other apps are required, preferably free.
Related categories: Atlassian Jira