I'm looking to automate the emailing of acknowledgement letters. Has anyone built a report/script to do this?
Adam D. Martens Director of PhilanthropyFlorida Studio Theatre
1241 N. Palm Ave. Sarasota, FL 34236-5602ph: (941) 366-9017 ext. 316cell: (941) 735-5774fax: (941) 955-4137 amartens@floridastudiotheatre.orgwww.floridastudiotheatre.org
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?
I'm not sure if it is the same in a development transaction but the easiest way to do this in ticketing orders is by setting up various email acknowledgment templates to appear under the "Print Order" screen. This method only adds an extra second to the order time since the ticket rep already must hit "Print Order" to print the tickets and/or receipts. When the print order screen opens you can check the box next to acknowledgment and select the desired email acknowledgment and click OK. This includes any fees or contributions added in the order. Is it possible this is available in the development module?
Chuck Buchanan
92nd Street Y
Hi Charles,
Do you have the ability to send out email confirmations in the ticketing order when there are no ticketing products in the cart, only contributions? We have been having some challenges with this :)
Cheers,
Nicholas