Merging into variable page documents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eclipse - 09 Feb 2006 00:54 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 09 Feb 2006 05:06 GMT

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/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

Signature

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

> Hi All,
>
[quoted text clipped - 12 lines]
>
> Terapixels

Reply to this Message