I am shocked that this isn't a very basic functionality, but no one seems to be able to give me a straight answer. To explain:
We have an event this Sunday. We're allowing people to register right up to when the event begins. We would simply like to be able to send out an email right when the event starts to say, "Hey, here's the link to the event!" I would like to schedule this email in advance.
Has anyone found a basic way to create a dynamic list of registrants for an event with emails? Every time I pull anyone with the correct ticket history, but because ticket history only updates overnight I have to then look at anyone who had done an order that day to see if their order was for the right event, and then I have to basically manually put the lists together. Surely someone has a solution! Will I just have to end up writing some SQL here?
Have you tried using the Order Export Utility located under Reports and Utilities to generate your list of emails for that performance?
Hm, I get an error here that I'm unable to pull it because I haven't filled in a certain Parameter that is not an option for me (so there must be something wrong with the way the utility is built in our environment I suppose?)
But yes, this looks like a decent solution for pulling an event or several. However, we sometimes want to pull our class roster which is around 40 classes taking place over four days. So I'd either have to go through and select each one individually, or pull one day at a time using the performance start date and performance end date options.
Although, I'm still left with the issue of it not being a dynamic email list I can set for the weekend. That being said, thank you very much for the help!! This will definitely make things easier for when I just need a few events!
Could it be that you didn't click the Next button and select/enter another parameter? Some reports/utilities have the Next button active and you need to enter/select additional parameters. Whenever I get an error I double check what I selected and check for the Next button.