Word/Excel Question

[BananaPancakes]

So here's the problem.

I'm in charge of printing award certificates for some students. I've got the template for it nicely formatted in Word but I really want to avoid typing up their names, courses, and date graduated in manually.

Is there a way to type them as rows in Excel or something, and then export them to Word into a variable text field so that they I can print them automatically?

Right now, I'm manually changing the name, course, and date, and then hitting print, and repeating dozens of times every month.

Any possible solutions would be awesome. Thanks.

[Old Yeller]

I've only done it with querying an online database, but a quick google looks like it can be done with excel.

Google "word mail merge with excel".

[Arsenal14]

Agreed with Old Yeller, mail merge is the answer. Here is one sample walkthrough of the process (there are a ton of examples on the web).

[BananaPancakes]

This is exactly what I was looking for. Thanks a bunch guys!