Send out Email with variable code for entrance ticket?
I have got a csv-file containing entrances codes for a trade show (simple hexadecimal codes). After a user submitted a form on a landing page we want to send out an automated Email with the entrance code - for the user to get a ticket on the show's web page. Every code can only used once.
How can I implement the selection of the codes out of my csv-file?
I thought about adding the code as a contact property by useing a hidden field in my form or by running the contact trough a workflow. But I could not find a way to ad a variable value there. As an alternative I tried to add a placeholder into my email which accesses the csv-file. However, so far I was not able to realize any of these ideas. :-(
Thanks for any thoughts!