Question to MailMerge expert

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

Doug
Sun May 11 15:07:10 PDT 2008

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/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

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" <Zoska@Zoska.com> wrote in message
news:g07jsb$alk$1@atlantis.news.neostrada.pl...
> 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
>