Merging data

[Guest]

I am trying to find a way to take data from excel and merge that data in to
mutiple spreadsheets in either word or excel. For example, the data in the
excel spreadsheet would list specific employee information (age, date of
birth, name, etc.). I would have a template that I would want the data to
dump in to but I would want the template to become a page or spreadsheet for
each employee. Please help if you are familiar with a way for me to do this.
Thank you!

 

[Guest]

Try using mail merge in Word. The main document (template) would be in Word
and in there you put all the standard information that stays the same and you
can then link that document to the Excel data file, put the merge fields into
the Word document where you want to put the information and merge them
together so that you have each set of information on a new page. There is a
wizard in Word to step you through the process. In Word 2003 it's under
Tools / Letters and Mailings / Mail Merge which then displays the mail merge
task pane with the wizard. In Word 2000, it's under Tools / Mail Merge.