Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-18-2009, 04:31 AM
PaulAtrib PaulAtrib is offline Creating Certificate Windows XP Creating Certificate Office 2007
Novice
Creating Certificate
 
Join Date: Jun 2009
Posts: 1
PaulAtrib is on a distinguished road
Default Creating Certificate

Hello,
I'm writing from a language academy and this year we would like to create certificates for all students that complete our courses. Using an excel document that has the students name(A1), date they began the course (B1) and the course level (C1). The final result will look something like this:
School Logo

This is to certify that:
(Full Name)

from (course beginning date) to June 2009 has attended classes with the level (course level)

Signed,

Me
I'm not sure if this is something we need to do between Word and Excel or between other programs using Office. But any help would be greatly appreciated!



Thanks,
Paul
Reply With Quote
  #2  
Old 06-19-2009, 03:27 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Creating Certificate Creating Certificate Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

I would suggest creating the certificate in Publisher - exporting it to Word - and then setting it up as a mail merge template to your Excel name database.

If you created the merge to a particular place (ie. the Desktop) before you save it as a template - all you would need to do in the future is create the Excel file and drop it on the desktop before you open the Template and it will automatically pick up the data when it opens!!


Also, please remember that there are thousands of great free templates on www.microsoftoffice.com. You can spend ages creating one from scratch - far easier to get an idea, or initial design.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with creating reports!!!Help? beginer Project 0 06-15-2009 11:30 AM
Creating Certificate Creating Hyperlinks alicein1derville Excel 5 02-08-2009 10:31 PM
Creating a special Document darka5sa5sin Word 0 02-06-2009 11:23 AM
Creating A Hyperlink Techknology Outlook 0 11-30-2006 01:16 PM
Creating new project Using PDS myanilkumar Project 0 01-05-2006 12:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft