How to automatize the making and sending of event's attendance certificates? Our department make a lot of attendance certificates, for events we run, and we waste a lot of work typing attendance lists and sending them by email. Most of the public are students are from my institution, and we can get a list of names and email address. We make about 1.500 certificates by year.

We are thinking about using a event system, but I'm having trouble to find one that makes certificates and don't cost thousand of dollars.

Anyone have a suggestion? A better solution?
I suggested in my comment that you could search on Stack Overflow for a mailmerge or vba solution.

This is one example of printing sheets that you could adapt to your situation: 
https://stackoverflow.com/q/46332953/4961700