Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2011, 03:54 PM
conradin conradin is offline Input from excel, output to word Windows XP Input from excel, output to word Office 2007
Novice
Input from excel, output to word
 
Join Date: Apr 2011
Posts: 2
conradin is on a distinguished road
Question Input from excel, output to word


Hi all,
I am considering writing a program to do a file IO task in excel and word, but I am just wondering if such functionality already exists in the MS Office 2007 suite.

Here is What I'm trying to do: I have a spreadsheet with 250 student names and professor names. I have a word document I want to use as a template for all the documents. On each document, I want a certain student and professor's name read in from the spreadsheet. This is to print certificates for student achievements. Entering 250 names from a spreadsheet into word seems ridiculous. Does any one know a simple way to make this happen?
Reply With Quote
  #2  
Old 04-20-2011, 04:01 PM
BrazzellMarketing BrazzellMarketing is offline Input from excel, output to word Windows XP Input from excel, output to word Office 2007
Competent Performer
 
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road
Default

Yes, Word is already set up to do this. It's called mail merge. Here's a tutorial:

http://wordprocessing.about.com/od/m...app=ZWD&ver=12
Reply With Quote
  #3  
Old 04-20-2011, 06:57 PM
macropod's Avatar
macropod macropod is offline Input from excel, output to word Windows 7 32bit Input from excel, output to word Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

See also: http://word.mvps.org/FAQs/MailMerge/index.htm
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-20-2011, 07:48 PM
conradin conradin is offline Input from excel, output to word Windows XP Input from excel, output to word Office 2007
Novice
Input from excel, output to word
 
Join Date: Apr 2011
Posts: 2
conradin is on a distinguished road
Default

I was skeptical at first about the name "MailMerge", but It works Exactly as I need it to!
Thank You BrazzellMarketing!!
Reply With Quote
Reply

Tags
excel 2007, macros, word 2007



Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM
Merge Fields, Pictures and output to email (with attachment) schilds71 Mail Merge 0 10-21-2010 12:02 PM
Output Presentation Settings yeapurvz10 PowerPoint 0 09-17-2010 10:30 AM
Automatic Date Function Corrupting Printer Output Theodulf Word 0 05-28-2010 12:33 PM
Creating A Input Or Output Field skoz55 Excel 0 08-15-2009 04:40 PM

Other Forums: Access Forums

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