J
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?
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?