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

Modified on Fri, 08 Sep 2023 at 04:10 PM

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=sample@gmail.com&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.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article