• Welcome to Tux Reports: Where Penguins Fly. We hope you find the topics varied, interesting, and worthy of your time. Please become a member and join in the discussions.

taking info from one document and auto filling others

S

SpannerX

Flightless Bird
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?
 
J

JoAnn Paules [MVP]

Flightless Bird
You could set everything up as a mail merge.

--
JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"SpannerX" <SpannerX@discussions.microsoft.com> wrote in message
news:1D168E6D-141C-44A5-9A2D-26DCF744FB79@microsoft.com...
> 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?
 
S

Steve Rindsberg

Flightless Bird
In article <1D168E6D-141C-44A5-9A2D-26DCF744FB79@microsoft.com>, SpannerX
wrote:
> 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/
 
Top