excel and word

[jcontrer]

I have a spreadsheet containing information on about 600 employees (name,
idnumber, department, position... etc) I also have a word document, a survey
form which i need those employees to fill out. I would like to personalize
each survey with information from the spreadsheet. Is there a way in which
this can be automated? the surveys will be printed and sent out. the
information that i would like put into the survey from the spreadsheet is id
number (column a) last name (column b) first name (column c) department
(column h) and job title (column i). One more thing, There might be more than
one entry per person but i only want 1 survey sent to each employee.
My questions are. can that be done? (i'm pretty sure it can)
how do i do that?

 

[HKaplan]

Simple mail merge. In Word 2003, open Tools | Letters & Mailings |
Mail Merge. Follow the instructions. Once it links your word doc to
the xl sheet, you will be able to place field names in the word doc.
Merge will do the rest. You can remove records in the merge wizard or
move them off the table in xl first.