How to auto-populate details for your customer when sending out a mass email

Now with SimpleTix, you can custom link for each of your attendees which when clicked on would auto-populate all the details.

This is useful in case you as an organizer would like to do a mail-merge for your event to sell tickets. Here is how to do it and following information can be auto-populated

• Promo Code
• First Name
• Last Name
• City
• State
• Autoopen=1 (This is required for it to work but can be set to 0) Buy ticket page will not open automatically if set to 0
• Email
• Phone

Here is a sample link: https://greatestcultfilms.simpletix.com/e/60500?promocode=aron101&firstname=Lizzie&lastname=Deignan&city=Madrid&state=NC&autoopen=1@[email protected]&phone=123-456-7890

You can skip the tags that you don't need to import if you want to skip it. Now let's create an excel file which you can then use for mail-merge

• Please open up excel and use the fields that you would like to have.
  Use the following formula on the last link to concatenate all the values.
  =CONCATENATE("EventLinkGoesHere?","promocode=",A2,"&firstname=",B2,"&lastname=",C2,"&city=",D2,"&state=",E2,"&autoopen=",F2,"&email=",G2,"&phone=",H2)
  
  
  
  
• Now we can test these individual links. Once clicked upon
  
  

  
  

  
  
• This excel file can now be used to mail merge with the last column which has the correct link for each attendee.