How to automatize the making and sending of event's attendance certificates?
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