[digifigi]

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

[Suzanne S. Barnhill]

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

[digifigi]

Could there be a conditional statement after each section break that would
change the header?
--
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

[digifigi]

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

[Suzanne S. Barnhill]

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

[digifigi]

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

[Beth Melton]

It sounds like you need a One-to-Many merge. Here are a couple articles that
might help with this task:

http://support.microsoft.com/default...b;en-us;211303

http://homepage.swissonline.ch/cindy...r/mergfaq1.htm (see Group items
for a single condition)

If your Excel data also contains the class in each student record then it
might be easier to import the Excel data in Access and create your report.
Access is better-suited for Grouping and Sorting and that's what you are
looking for.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/boo...x#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"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

[Suzanne S. Barnhill]

I don't believe you can successfully put merge fields in headers, but I may
be wrong.

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

"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

[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