1. Go to Analysis >Information Library.  Click Add an ad-hoc query.  Select Sales order source view and click Ok
  2. On the left column, expand sales order item, sales order item ticket.  Click on Program Events.  In the middle, click Event record and move to Include Records Where.  Search for your program event and click OK.
  3. On the left column, expand Tickets under sales order item, sales order item ticket.  In the middle column, click scan date and move to Include Records Where.  Set the criteria to Not Blank.
  4. On the left column, click on the plus sign next to Constituent, then click Email Addresses.  In the middle, click primary email address and move to Include Records Where and set the criteria to equal to yes.  Note: this will return only primary email addresses and people without email addresses will not be included.
  5. In the middle column, click Email Address and move to Results Fields to Display.
  6. On the left column, click on constituent.  Click name and move to Results Fields to Display.
  7. Go to the Set Save Options tab, name and save your query.