taking info from one document and auto filling others

[SpannerX]

Okay, my subject might not describe it exactly, but here is what I want to
do, to try and automate this task I have to do on a regular basis.

What I do is I type up an attendance sheet for training, and then I have to
take the same info and make up training certs for the people that attended
the training. Is there anyway that I can just take the names and the course
and automatically make certs based on the attendance sheet?

 

[JoAnn Paules [MVP]]

You could set everything up as a mail merge.

 

[Steve Rindsberg]

Okay, my subject might not describe it exactly, but here is what I want to
do, to try and automate this task I have to do on a regular basis.

What I do is I type up an attendance sheet for training, and then I have to
take the same info and make up training certs for the people that attended
the training. Is there anyway that I can just take the names and the course
and automatically make certs based on the attendance sheet?

As JoAnn says, you can merge print using Word.

We also have a commercial add-in that lets you merge data from Excel etc. into
PowerPoint slides, in case you prefer to create your certificates in PPT.

Free demo at http://www.pptools.com/merge/