You might also want to check out mailmergic.com. It can take your Excel data and Word template and generate individual PDFs directly, without needing any VBA or macros.

It’s really straightforward to use and can save a lot of time compared to running Word macros, especially for large merges.