Hi All,

I have a spreadsheet with approximately 5000 students entries. Each entry
contains a student's progress in a subject. But each student may take a
different number of subjects.

For example, Student A may be the first five entries, then Student B may
have the next eight entries and so on.

I am trying to print merge the spreadsheet so that each student's progress
will print as a separate document so I can use the printer to staple them
together at the end of each print job.

Your help will be much appreciated.



Terapixels

If when you execute the merge to a new document, you get a document arranged
as you wish, from the page layout point of view, then if you run the
following macro over that document, it will send the information for each
student to the printer as a separate print job:

Dim i As Long
With ActiveDocument
For i = 1 To .Sections.Count
.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i
End With

However, I suspect that you are probably trying to perform a "multiple items
per condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

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


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"eclipse" wrote in message
...
Hi All,

I have a spreadsheet with approximately 5000 students entries. Each entry
contains a student's progress in a subject. But each student may take a
different number of subjects.

For example, Student A may be the first five entries, then Student B may
have the next eight entries and so on.

I am trying to print merge the spreadsheet so that each student's progress
will print as a separate document so I can use the printer to staple them
together at the end of each print job.

Your help will be much appreciated.



Terapixels