I have to make "class passes" every week. They Include the student's name,
Group color, homeroom teacher's name and room number, number of the room they
will be going to, and the date and time. It is very hard to type in all of
this data EVERY week... I have an excel spreadsheet that has all of this data
in it. How do I "get my computer" to just "fill in" the blanks? for example,
i have my data, and i press some key, and the names, teachers names, dates,
times, room #s, etc. are filled in automatically. I've tried to make a
template, i just dont know how to get it to "work". by the way, i have to
wake up at 6 on every tuesday morning and fill in 54 passes. help???

Try mailmerge

"breezemagic101" wrote:

I have to make "class passes" every week. They Include the student's name,
Group color, homeroom teacher's name and room number, number of the room they
will be going to, and the date and time. It is very hard to type in all of
this data EVERY week... I have an excel spreadsheet that has all of this data
in it. How do I "get my computer" to just "fill in" the blanks? for example,
i have my data, and i press some key, and the names, teachers names, dates,
times, room #s, etc. are filled in automatically. I've tried to make a
template, i just dont know how to get it to "work". by the way, i have to
wake up at 6 on every tuesday morning and fill in 54 passes. help???

Hi breezemagic101,

Assuming your workbook has the data for all students on a single worksheet and each student's data is on a single row, a Word
mailmerge would do the job. For what you've described, a label merge is most likely the kind of merge you'll need.

--
Cheers
macropod
[Microsoft MVP - Word]


"breezemagic101" wrote in message
...
I have to make "class passes" every week. They Include the student's name,
Group color, homeroom teacher's name and room number, number of the room they
will be going to, and the date and time. It is very hard to type in all of
this data EVERY week... I have an excel spreadsheet that has all of this data
in it. How do I "get my computer" to just "fill in" the blanks? for example,
i have my data, and i press some key, and the names, teachers names, dates,
times, room #s, etc. are filled in automatically. I've tried to make a
template, i just dont know how to get it to "work". by the way, i have to
wake up at 6 on every tuesday morning and fill in 54 passes. help???