taking info from one document and auto filling others
in [Microsoft Office]
|
Prev: Do you use OpenOffice and do you find it is not compatible with Office Word?
Next: Powerpoint Mac problem
From: SpannerX on 12 Apr 2010 09:01 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?
From: JoAnn Paules [MVP] on 12 Apr 2010 09:23 You could set everything up as a mail merge. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "SpannerX" <SpannerX(a)discussions.microsoft.com> wrote in message news:1D168E6D-141C-44A5-9A2D-26DCF744FB79(a)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?
From: Steve Rindsberg on 12 Apr 2010 15:44
In article <1D168E6D-141C-44A5-9A2D-26DCF744FB79(a)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/ |