View Single Post
 
Old 04-20-2014, 04:16 AM
unittwentyfive unittwentyfive is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2013
Location: At sea!
Posts: 10
unittwentyfive is on a distinguished road
Default Trying to make several lists in Word, from data in Excel.

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
Reply With Quote