I have a staff of about 20 people at a time. We work on rotating contracts, so there can be several new people each week, and several people leaving. There are a few checklists, phone lists, signups, etc, that all have to be made new each week to reflect the current 20 people on staff. I have been doing this manually, but I figure that there's got to be a better way.



I've made up the list in Excel, separated into columns that cover all the various data that are required on the individual pages. I'd like to make up some "template" type Word documents, that auto-populate with the relevant information when I open them, based on what's currently in the Excel document.

Specifically, the phone list would pull their First Name, Last Name, Title, and, Extension Number. The weekly safety review sheet would pull their First Name, Last Name, Job Code, Employee ID number, etc.

Is there a way to get Word to make it so that each line of the table is considered a different "mailing label" or something like that?

Thanks!
~Joe