Re: print mass Powerpoint certificates from Excel file
Steve Rindsberg
wrote:
> I get Excel lists of students that require training certificates. I have a
> PowerPoint certificate. Is it possible to do something simular to a mail
> merge?
Not out of the box, but we have a commercial PowerPoint add-in that does
exactly this. You can try out a fully functional demo to see if it meets your
needs. More info here:
==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/
PPTools add-ins for PowerPoint
http://www.pptools.com/
Sethu V
I had a similar problem and discovered a dead simple solution. Here are the steps.
1. In the ppt choose "Edit > Select All" (You can skip header/footer if not required) and Copy (Ctrl C)
2. Open a new word file and go to "File > Page setup" and choose "Landscape" layout mode (it is best for ppt slides)
3. Go to the Drawing tool bar and (if it is not visible, go to "Toolbar - Drawing". In the Drawing tool bar, click any shape (say circle). On clicking, an outline rectangular box will open up in the word document page. (Dont worry about the circle created, you can delete it later, it is just to invoke the "rectangular drawing area box"
4. Rt click your mouse in the drawing area (now shown as outlined rectangle), and just paste the ppt certificate content that you had copied in Step 1 above
5. The ppt slide content is now visible inside the drawing box. You can edit the content just by simple mouse click. At this point you have fully "editable" ppt content within a word document in landscape mode
From hereon, you can follow the standard Word Mail merge procedure (Tools > Letters and Mailings > Mail Merge > Letters (or email) and create do a regular mail merge using data sources (xl data, CSV, txt file etc).
After setting up the mail merge, simply send it as e-mail (or) "print to pdf" (or) Print to file.
Using the above method, I printed out 450 certificates which contained 4 fields that were merged from an xl sheet (Student Name, Project Name, Scores, Certificate #)
Try it out and I am sure it will solve your problem!!
No need for any add-ons or extra s/w, just MS office functionality is good enough to get this done!!
Cheers!!
Sethu V
eXample Consulting Group
http://www.eXampleCG.com
(Enabling Excellence!!)
> On Wednesday, December 23, 2009 9:30 AM Go to Girl wrote:
> I get Excel lists of students that require training certificates. I have a
> PowerPoint certificate. Is it possible to do something simular to a mail
> merge?
>> On Wednesday, December 23, 2009 10:26 AM Steve Rindsberg wrote:
>> wrote:
>>
>> Not out of the box, but we have a commercial PowerPoint add-in that does
>> exactly this. You can try out a fully functional demo to see if it meets your
>> needs. More info here:
>>
>> http://www.pptools.com/merge/
>>
>>
>>
>> ==============================
>> PPT Frequently Asked Questions
>> http://www.pptfaq.com/
>>
>> PPTools add-ins for PowerPoint
>> http://www.pptools.com/
>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>> Silverlight 3D Animated Topic Selector With Titled Menu Items
>> http://www.eggheadcafe.com/tutorials/aspnet/1add6e1c-6c70-4c2f-8b1a-5187961e5414/silverlight-3d-animated-topic-selector-with-titled-menu-items.aspx
Sethu V
Cheers!!
>>> On Wednesday, November 03, 2010 10:47 AM Sethu V wrote:
>>> Hi,
>>>
>>> I had a similar problem and discovered a dead simple solution. Here are the steps.
>>>
>>>
>>>
>>> 1. In the ppt choose "Edit > Select All" (You can skip header/footer if not required) and Copy (Ctrl C)
>>>
>>>
>>>
>>> 2. Open a new word file and go to "File > Page setup" and choose "Landscape" layout mode (it is best for ppt slides)
>>>
>>>
>>>
>>> 3. Go to the Drawing tool bar and (if it is not visible, go to "Toolbar - Drawing". In the Drawing tool bar, click any shape (say circle). On clicking, an outline rectangular box will open up in the word document page. (Dont worry about the circle created, you can delete it later, it is just to invoke the "rectangular drawing area box"
>>>
>>>
>>>
>>> 4. Rt click your mouse in the drawing area (now shown as outlined rectangle), and just paste the ppt certificate content that you had copied in Step 1 above
>>>
>>>
>>>
>>> 5. The ppt slide content is now visible inside the drawing box. You can edit the content just by simple mouse click. At this point you have fully "editable" ppt content within a word document in landscape mode
>>>
>>>
>>>
>>> From hereon, you can follow the standard Word Mail merge procedure (Tools > Letters and Mailings > Mail Merge > Letters (or email) and create do a regular mail merge using data sources (xl data, CSV, txt file etc).
>>>
>>>
>>>
>>> After setting up the mail merge, simply send it as e-mail (or) "print to pdf" (or) Print to file.
>>>
>>>
>>>
>>> Using the above method, I printed out 450 certificates which contained 4 fields that were merged from an xl sheet (Student Name, Project Name, Scores, Certificate #)
>>>
>>>
>>>
>>> Try it out and I am sure it will solve your problem!!
>>>
>>>
>>>
>>> No need for any add-ons or extra s/w, just MS office functionality is good enough to get this done!!
>>>
>>>
>>>
>>> Cheers!!
>>>
>>>
>>>
>>> Sethu V
>>>
>>> eXample Consulting Group
>>>
>>> http://www.eXampleCG.com
>>>
>>> (Enabling Excellence!!)
>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>> Using the ASP.NET CustomValidator Control
>>> http://www.eggheadcafe.com/tutorials/aspnet/e622d48f-2787-4906-b97f-1ef8037a688f/using-the-aspnet-customvalidator-control.aspx