Word MailMerge - repeat some fields if next row same Client

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Turbo_Shark - 05 Jun 2006 17:49 GMT

I'm trying to mailmerge from Excel 2003 into Word 2003.

Each client could have 1 or more records.

I want one letter for each client, displaying each of the items and an
amount in a tabular format eg.

Mr X

Item No Amount
1 10.00
2 20.00

I have tried using {Next Record If} but am getting spurious results.

Reply to this Message

Doug Robbins - Word MVP - 05 Jun 2006 18:21 GMT

You are 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

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

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

> I'm trying to mailmerge from Excel 2003 into Word 2003.
>
[quoted text clipped - 10 lines]
>
> I have tried using {Next Record If} but am getting spurious results.

Reply to this Message

Turbo_Shark - 06 Jun 2006 12:41 GMT

> You are trying to perform a "multiple items per condition (=key field)"
> mailmerge which Word does not really have the ability to do:
[quoted text clipped - 26 lines]
>
> Thanks Doug - I don't think this warrants the pain of working out the If statements. Going to cross tab the source data then have [Item1], [Amt1], [Item2] [Amt2] etc... Think they only have max 4 rows so easier to suppress blank fields. As a database developer it is quite frustrating to find that Word does not support this type of functionality.

Reply to this Message

Doug Robbins - Word MVP - 06 Jun 2006 19:39 GMT

As a database developer, I would use a report to produce the result.

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

>> You are trying to perform a "multiple items per condition (=key field)"
>> mailmerge which Word does not really have the ability to do:
[quoted text clipped - 30 lines]
>> suppress blank fields. As a database developer it is quite frustrating to
>> find that Word does not support this type of functionality.

Reply to this Message

Rate this thread: