Seating Chart Merge

[jschping]

Hi,

I want to make a seating chart for my student's finals testing.

I want to use Mail Merge so I can create the charts, and then edit
individual parts.

I have an Excel spreadsheet with each student's name, their room number, row
number, seat number.

I want to make a chart that is a visual aid to where they sit. So I don't
jsut want a table listing of names and rows, I want it to come out in the
rows and in the right order. It doesn't have to be spectacular, but it should
be a visual aid.

For example:

------------------------------ROOM 201

ROW 1------------ROW 2------------- ROW 3--------------- ROW 4

Jack Frost----- Amelia Earheart--- George Washington -----Joe Shmoe

Marie Curie----- Abe Lincoln --------Hillary Clinton -------Marc Summers

(The lines are just to hold the place so you can see where everything should
be.)

And then do the next room.

How should I do this? The hard part (I think) is getting multiple columns
that each have a
different record. I want to have each row of students vertically, but if I
use mail merge, how do I do the "Next Record"?

Also, it needs to be sorted by room and row and seat number, and not all the
rows are full!

Thanks!

[Doug Robbins - Word MVP]

In your mail merge main document, insert a one row four column table and
in each of the cells of that table insert the mergefield(s) that
contain(s) the the names of the students. Before the first mergefield
in the second through fourth column, insert a <<Next Record>> field.

When you execute that merge to a new document, that document will
contain a table with the student names arranged in four columns.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my
services on a paid professional basis.

[jschping]

Hi,

Thanks for replying.

That will work for one room, but I have multiple rooms of students. Is there
a way to have Word automatically make a new section for a new room?

Thanks!

> .
>

[Doug Robbins - Word MVP]

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.

"jschping" <jsch...@discussions.microsoft.com> wrote in message
news:AEF090DA-F228-48BA...@microsoft.com...