Sounds like 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
or at:
http://cornell.veplan.net/article.aspx?&a=3815
--
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
"Zoska" wrote in message
...
Hi,
I have been using MailMerge for some time, usually to get
1 Word page from each Excel record.
Sometimes I use Skip a record if... when I want to skip some
records.
Now I have a new task and problem.
Fields (columns) in an Excel sheet are grouped into 3 groups,
each connected with different subject. Each subject must be
merged into a separate Word page. However in some records
all data for a subject can be equal to zero, so from 1 Excel
record I can get 1 or 2 or 3 Word pages depending on the data.
So the question is: how to get 1 or 2 or 3 Word pages from
each Excel record using the MailMerge?
I still use the MS Office 97 but if necessary I can install w newer
version of the programs.
I would be very grateful if someone could help me.
Regards,
Zoska