Question to MailMerge expert

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zoska - 11 May 2008 21:09 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 11 May 2008 23:07 GMT

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

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,
>
[quoted text clipped - 20 lines]
> Regards,
> Zoska

Reply to this Message