I'm looking to automate the emailing of acknowledgement letters. Has anyone built a report/script to do this?
I like the idea. We have not done anything like this yet. But I would imagine that the existing AP_ACKNOWLEDGEMENT_LETTERS stored proc would be a good starting poiint for getting the data for the acknowledgement emails. Then to use SQL mail to send out the emails.
My org would love to do this (many other also I am sure!).
I know this is an old thread, but has anyone made progress on automated emailing of acknowledgments?
We're currently emailing automatic confirmations from our order screen for our customer service reps. They place a flag on the order through the order custom screen which is then picked up by a sql script running in the background which chooses the confirmation to send based on choice made by the operator when they flag the order. Once sent, the flag is switched to either sent or failed depending on the action applicable. Failed informs the operator, by email, that their request failed so they can rescheduled it. The fail is based (ususally) on an un-emailable e-address or a missing e-address.
Our website, of course, is currently automated through the web api but we're looking to abandon this method in favour of a trigger as above or, alternatively a hook which will allow our Mail2 service to send a much more glamorous email.
Does this help at all?