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?

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

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

See also: http://word.mvps.org/FAQs/MailMerge/index.htm

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]