I am using mail merge to get data from excel to word. My problem is,
that i have variable excel source, in which I need to use several lines
into single word document, that means, not each new line should
automaticly be new 'mail' in word.
example:
ID status name cash
1 D aaa 111
1 D bbb 222
1 I ccc 333
1 O ddd 444
2 D eee 555
2 O fff 666
3 I ggg 777
in this document, i need new mail only for unique ID , and in this i
need to include into new page separately all lines with same status
so the word documents would look like
1) 1st document
1st page
D aaa 111
D bbb 222
2nd page
I ccc 333
3rd page
O ddd 444
2) - 2nd document
1st page
D eee 555
2nd page
blank
3rd page
O fff 666
3) - 3rd document
1st page
blank
2nd page
I ggg 777
3rd page
blank..

i hope it's written good enough to understand.
so, is it possible to even create something like this using standard
tools, or absolutely not?, and if so, then how to create some kind of
cycle there (WHILE ID="" and STATUS="" get all lines)

(and please excuse my rather poor english, i'm not a native speaker:)

Word MVP Cindy Meister has merging instructions that may help you:

http://homepage.swissonline.ch/cindy...r/MergFram.htm

Under Special Merges, click Multiple items per condition.


wrote:
I am using mail merge to get data from excel to word. My problem is,
that i have variable excel source, in which I need to use several lines
into single word document, that means, not each new line should
automaticly be new 'mail' in word.
example:
ID status name cash
1 D aaa 111
1 D bbb 222
1 I ccc 333
1 O ddd 444
2 D eee 555
2 O fff 666
3 I ggg 777
in this document, i need new mail only for unique ID , and in this i
need to include into new page separately all lines with same status
so the word documents would look like
1) 1st document
1st page
D aaa 111
D bbb 222
2nd page
I ccc 333
3rd page
O ddd 444
2) - 2nd document
1st page
D eee 555
2nd page
blank
3rd page
O fff 666
3) - 3rd document
1st page
blank
2nd page
I ggg 777
3rd page
blank..

i hope it's written good enough to understand.
so, is it possible to even create something like this using standard
tools, or absolutely not?, and if so, then how to create some kind of
cycle there (WHILE ID="" and STATUS="" get all lines)

(and please excuse my rather poor english, i'm not a native speaker:)



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html