Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
#9
Posted to microsoft.public.word.newusers
|
|||
|
|||
Non-repeating Text in Mail Merge
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I suppress repeating headings in mail merge? | Mailmerge | |||
How do I stop mail merge address block repeating fields twice? | Mailmerge | |||
How to create subheadings for repeating field in mail merge direct | Mailmerge | |||
Problems w/ names repeating on a badge mail merge | Mailmerge | |||
mail merge is repeating names from excel document, why? | Mailmerge |