Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-16-2012, 09:37 AM
LS1015 LS1015 is offline Print word form using excel data sheet Mac OS X Print word form using excel data sheet Office for Mac 2011
Novice
Print word form using excel data sheet
 
Join Date: Jul 2012
Posts: 1
LS1015 is on a distinguished road
Default Print word form using excel data sheet

Good morning,



I am currently working with a word document to create student certificates. I have students' names on an excel workbook sheet by class. I am looking for a way to combine the names into the word certificate to print "all" showing the different student names. I have attached a sample of the word certificate. If there is any possible way to achieve this, please advise. Thanks
Attached Files
File Type: docx Science Award Template.docx (472.3 KB, 8 views)
Reply With Quote
  #2  
Old 07-16-2012, 08:16 PM
macropod's Avatar
macropod macropod is offline Print word form using excel data sheet Windows 7 64bit Print word form using excel data sheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You should consider using Word's mailmerge tools for this. Provided your Excel data are laid out with one row per student, and columns holding their names and classes, it is all quite straightforward.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Print word form using excel data sheet Print Excel data as reciepts? halix2000 Excel 3 04-30-2012 11:13 PM
sheet 2 data highlight in sheet 1 gsrikanth Excel 1 04-21-2012 06:25 PM
Print word form using excel data sheet Link data from embedded excel sheet rwbarrett Word 1 05-27-2011 02:05 AM
Print word form using excel data sheet Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM
Outlook Form that Saves Data to Excel dcbrown Outlook 0 12-29-2008 06:25 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 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