Hallo,
in our company we use Word merge for some Agreements. No problem to specify commands IF for example:
{ IF { MERGEFIELD name }<>"" { MERGEFIELD birh no } "................" } etc.
but this is only to specify only for column record,,,,

Excel:
1st row.... LV = 1, name = Mr. Black
2nd row... LV = 1, name = Mr. Brown
3rd row... LV = 1, name = Mrs. Brown
4th row... LV = 2, name = Mr. Blue
5th row... LV = 3, name = Mrs. Blue
6th row... LV = 3, name = Mr. White
..
..
etc.



Word: (merge to Excel)
1st Agreement for LV = 1.... 3 people on one page (Mr. Black, Mr. Brown, Mrs. Brown)2nd Agreement for LV = 2.... 1 people on one page (Mr. Blue)
3rd Agreement for LV = 3.... 2 people on one page (Mrs. Blue, Mr. White)..
..
etc.

Many thanks.

Jerry (CZ)

Hi Jerry,

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010)
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.


For some recent, worked examples, see the attachment to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327


Alternatively, you may want to try a Many-to-One Mail Merge add-in from either:
• Graham Mayor at: http://www.gmayor.com/ManyToOne.htm
• Doug Robbins' Windows Live SkyDrive page at: https://skydrive.live.com/?cid=5aedc...615E886B%21111

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hallo macropod,
i try it, but i don´t understand. I send you web link to download my merge Word vs Excel files (seznam.cz + šablona...doc) sorry in Czech.

See you to Word text box where I try to explain my problem.

Many many thanks.

Jerry


Here is: http://www.sdhhornizlebmmdecin.czweb.org/merge/TEST.ZIP

Macros in Excel, Word must be enabled...

Which one did you try? Have you read the tutorial and experimented with its examples? Have you looked at the examples in the links I provided? I have looked at your document and, apart from the fact that I have no idea what your document is about (I don't read Czech), I cannot see any indication that you have tried to use any of the tutorial examples.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]