Automate report to email a list of open PO's to suppliers with a click of a button with the following language in the email.
"This is an automated message from Hoyt Archery in Salt Lake City, Utah to " & vendorname & ". Attached is a list of all open orders. Please review these open orders for accuracy to ensure that they are currently in process and confirm the estimated delivery dates. If there are any late line items (highlighted in red), please use the attached file and complete the 'Recovery Plan' field to update Hoyt Archery as to the status and plan for each of the late items.
Please return the document to " & BuyerEmail & " at Hoyt within 2 business days. Please do not respond directly to this email. Thank you.
Orders should be sorted by Supplier name, then Delivery Date. All late orders (orders that have reached the delivery date) should be be background red, font white. The file that is sent to the supplier should be in .xls format with the final column titled "Recovery Plan".