Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel and word
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? -- thanks in advance for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Word copying info from Excel to Word without gridlines / bor | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Link table from excel to word using word VBA | Excel Discussion (Misc queries) | |||
Excel Hyperlink doesn't open Word doc the same way as Word does | Excel Discussion (Misc queries) | |||
Print labels by using Excel data in a Word mail into word | Excel Discussion (Misc queries) |