[Graham Mayor]

You are not

From the description of the data records you are not going to be able to
achieve this. Word merge will not work with relational databases, nor can
you extract bits of a field for use as a heading. You would need a flat data
file similar to the following:

Class1 John
Class1 Fred
Class1 Bill
Class1 Susan
Class2 John
Class2 Susan
Class3 Bill
Class3 Fred
etc. Then you might have a half decent chance of producing a merge that
displays the students agains the classes. See How to use mail merge to
create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686

You may however be able to achieve what you want by producing a report from
your database application eg Access, that would give the required layout.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Suzanne S. Barnhill wrote:
I don't believe you can successfully put merge fields in headers, but
I may be wrong.


"digifigi" wrote in message
...
Each class begins with a unique identifier, i.e., 104DA, or 216HS,
followed
by the name of the class. Unfortunately, each class is not in its
own field.
The fields are set up by day and type of class (Wednesday full day
has 6 different classes in the column or field, Thursday half day AM
has 4 different classes, etc.).
I just tried an If...Then statement in the header using both equals
the total name of a class and Not Blank. Neither returned the class
name provided. And I tried just the merge field and got a blank
header.
If the classes are numbered, you could probably use some sort of
field in the header. Can you provide more information about how the
classes are identified?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"digifigi" wrote in message
...
Sorry, I'm trying to automate this as much as possible since there
are over
100 classes.
--
digifigi


"Suzanne S. Barnhill" wrote:

I would suggest merging all the names first, into an ordinary
catalog/directory merge. After you've merged to a new document,
insert section breaks between classes and put the class names in
the header, or
just insert page breaks and put the class name at the top of the
page. --
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"digifigi" wrote in message
...
Using Word2007, I'm trying to create class rosters or a list of
names
of
students for specific classes in one document. I would like to
have
the
class name appear at the top of the page and the students listed
below.
I
can get one list using "skip if blank" and "if..then", but the
class name
keeps repeating for every record. I know I can put the class
name in
the
header, but I'd like to have more than one class in the document.
The
data
document is an excel file.
I haven't even tried to do more than one class in the document. Is
that
possible? Some students (which is what the individual records are
based
on)
are in more than one class.
--
digifigi