Hey everyone,
Thanks for any help in advance. Our organization is about to mail season letters to all of our 2019 subscribers. We need the basics for this letter - their name, tess and order #, as well as their exact dates and the seats relevant to that date. We have reserved packages with standard sets of production dates, but this information becomes harder to extract with our flex packages, when the patron's dates are all over the place and the seating inconsistent.
I have yet to locate a report that easily gives us this information that, when exported to a CSV or excel sheet, is easily transferable to a mail merged word document. Does anyone have any recommendations on this?
Thank you!
(We are still in v12.5.1 by the way)
Hi Tyler,
We're in a similar situation (we only sell flex packages) and our process isn't easy, but it works. Most of our season letters don't have performance information, we just print the tickets and let them get it from there. For those we can't print tickets for the process is multi-step, but it gets us there. I started from TP_ORDER_ACK, added a function to get seat locations, and flattened the output a little bit. Then I run my modified procedure in SSMS and put the data in Excel, where I can mail merge. However, since there's a row for each performance, the mail merge template has a good number of If statements. I inherited it, but would be happy to share if you are interested in trying to decode it for your own use.
Another option would be to create a new Confirmation Format in Infomaker and then run the Order Confirmation report. I don't think that has seat information, so there'd be more editing there as well.
Perhaps someone else will respond with a better solution I could take advantage of too!
Dorothy