printing certificates?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 06 Sep 2006 06:53 GMT

Hello,
I think I am going to go insane.LOL I am in the US Army and have
just finished a training class of 200 personnel and I have to print a
certificate for each of them. Is there a way to have powerpoint auto print a
certificate for each person or do I have to manuall type each persons name in
the text box? I have the certificate in powerpoint and the database with all
the names and in Excel. Any help would be greatly appreciated.

Reply to this Message

aneasiertomorrow - 06 Sep 2006 08:28 GMT

Hi Eric

There is probably a much simpler way but I would do it like this:
1. Get those names into Word in Heading Style 1 (mail merge from Excel) and
save & close the file
2. In PowerPoint set up the slide title placeholder to be where & formated
how you want the name to appear
3. In PowerPoint Insert->Slides from Outline->navigate to your document &
click Insert
4. Voila!

If you need any more info on the above steps post back (& let me know what
version of Office you're using)

Lucy

Signature

MOS Master Instructor
South Australia

If this post answered your question please let us know as others may be
interested too

> Hello,
> I think I am going to go insane.LOL I am in the US Army and have
[quoted text clipped - 3 lines]
> the text box? I have the certificate in powerpoint and the database with all
> the names and in Excel. Any help would be greatly appreciated.

Reply to this Message

aneasiertomorrow - 06 Sep 2006 08:46 GMT

Ooops! Point 2 should be done on the slide master, not just a slide btw. In
fact all graphics & text should be on the master (View->Master->slide master)

Lucy

Signature

MOS Master Instructor
South Australia

If this post answered your question please let us know as others may be
interested too

> Hi Eric
>
[quoted text clipped - 19 lines]
> > the text box? I have the certificate in powerpoint and the database with all
> > the names and in Excel. Any help would be greatly appreciated.

Reply to this Message

Bill Dilworth - 06 Sep 2006 08:40 GMT

Sounds like another job for PPT Merge.

Check out >http://www.rdpslides.com/pptools/merge/index.html and see if it
is what you are looking for.

Signature

Bill Dilworth
A proud member of the Microsoft PPT MVP Team
Users helping fellow users.
http://billdilworth.mvps.org
-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_
vestprog2@ Please read the PowerPoint FAQ pages.
yahoo. They answer most of our questions.
com www.pptfaq.com
.

> Hello,
> I think I am going to go insane.LOL I am in the US Army and have
[quoted text clipped - 6 lines]
> all
> the names and in Excel. Any help would be greatly appreciated.

Reply to this Message

John Wilson - 06 Sep 2006 11:19 GMT

Wouldnt this be easier in Word?

Signature

Did that answer the question / help?
_____________________________
John Wilson
Microsoft Certified Office Specialist
http://www.technologytrish.co.uk/ppttipshome.html

Reply to this Message

Steve Rindsberg - 06 Sep 2006 16:49 GMT

> Hello,
> I think I am going to go insane.

I'd stop using PowerPoint before it's too late, then.
Most of us are beyond hope here. <g>

> I am in the US Army and have
> just finished a training class of 200 personnel and I have to print a
> certificate for each of them. Is there a way to have powerpoint auto print a
> certificate for each person or do I have to manuall type each persons name in
> the text box? I have the certificate in powerpoint and the database with all
> the names and in Excel. Any help would be greatly appreciated.

As Bill's suggested, our PPT Merge add-in would do the job nicely. This is
exactly what it was originally written to do, though it's been expanded a lot
since then.

http://merge.pptools.com

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message