How can I generate individual link for each participant to pass in their email address?

I generate a general link through the lighthouse with a pass in the email address.
How can I generate 5000 links for each of my participants? I assume I should use excel and CONCATENATE function, is that a good way to do?

How can I send that individual link to each participant? is there any way?