[Zoska]

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

[Robert M. Franz (RMF)]

Hello Zoska

Zoska wrote:
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 _think_ what you need is a category type mailmerge. See for example:

How to use mail merge to create a list sorted by category in Word
http://support.microsoft.com/?scid=k...4686&x=10&y=16

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MSFT |
\ / | MVP | Scientific Reports
X Against HTML | for | with Word?
/ \ in e-mail & news | Word | http://www.masteringword.eu/