Non-repeating Text in Mail Merge

[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.

 

[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.

 

[digifigi]

Could there be a conditional statement after each section break that would
change the header?
--
digifigi

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.

 

[digifigi]

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

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]

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

Sorry, I'm trying to automate this as much as possible since there are
over
100 classes.

 

[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.

 

[Suzanne S. Barnhill]

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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>