Hello everyone
We currently have a use case where we want Purchase Order Requesters to receive, once a week, an e-mail detailing all PO Items - that have not yet been reported, in previous weeks - that have 20% or less of their budget remaining.
Where we need some input is, how do we send 1 e-mail per week, per Requester, containing only the Purchase Order Items assigned to them?
We're currently only capable of sending 1 e-mail to all the requestors present in the data, so what we seem to need is a way to Parse E-mails, based on Requestor, with all their aggregated data!
This information is present in a table's Columns, i.e:
Thank you very much in advance!
P.S: Bear in mind we cannot use Google's Services, so we're limited to using an E-mailing Skill:
Best Regards,
Vasco Carona