How to auto populate a jotform for the over 100 attendees in one go

HI,

I have a query, I have a 100 people confirmed to attend my event some through jot form and some through emails. However, I would like to send them an email campaign to activate their badges.

I am trying to understand how can I create a unique link for each attendee, when they click on the link and it opens the jot form on my website, prefilled with the data they have shared with me. 

Is this possible, I will be sending the email from my mail chimp with the activate your attendance link.

I hope what I am asking makes sense. As I want to send it for multiple attendees in one go. I am trying understnd if there is way where I can create a 100 links in one go.

I hope you can guide me.

Thanks.

The easiest way I can think of to accomplish this would be to export the data to a spreadsheet:

https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

Then add an additional column to the sheet to create the URL's.  The form can be populated using URL parameters:

https://www.jotform.com/help/71-Prepopulating-Fields-to-Your-JotForm-via-URL-Parameters

Either that or writing a script that pulls the data via API and creates the URL's, but that would likely be quite a bit more complex:

http://api.jotform.com/docs/