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 |
excel and word
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. |
All times are GMT +1. The time now is 05:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com