Best way to extract season ticket information for mail merge to constituents

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)

Parents
  • Former Member
    Former Member $organization

    Ticketing Processing > Order Export

    aka The God Report

    It will require data manipulation and confidence while using Excel, but this report can give you that which you desire without requiring any custom reporting.

Reply
  • Former Member
    Former Member $organization

    Ticketing Processing > Order Export

    aka The God Report

    It will require data manipulation and confidence while using Excel, but this report can give you that which you desire without requiring any custom reporting.

Children
No Data