Non-repeating Text in Mail Merge

  • Thread starter Thread starter digifigi
  • Start date Start date
D

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


Suzanne S. Barnhill said:
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.
Click to expand...
 
Sorry, I'm trying to automate this as much as possible since there are over
100 classes.
--
digifigi


Suzanne S. Barnhill said:
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.
Click to expand...
 
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 said:
Sorry, I'm trying to automate this as much as possible since there are
over
100 classes.
Click to expand...
 
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.
 
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.aspx?scid=kb;en-us;211303

http://homepage.swissonline.ch/cindymeister/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/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
I don't believe you can successfully put merge fields in headers, but I may
be wrong.
 
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

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

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

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Back
Top