[Glitter]

My data source has 4 or more rows of data for each record of my mail merge.
How can I set up the mail merge to grab more than 1 row of data (it needs to
be flexible) into 1 mail merged document. For example...

1 Record:
Customer A 123456 Address City State
Customer A 234561 Address City State
Customer A 345612 Address City State

Need it to come onto the letter like:

Customer A Address City State
123456
234561
345612

[macropod[_2_]]

See "Use Mail Merge to Create a List Sorted by Category in Word 2000":
http://support.microsoft.com/?kbid=211303

The following field code construction works better (and is simpler) than the one there, though:
{QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City} {Place} "{IF{MERGESEQ}= 1 "" "ENTER
"}{MERGEFIELD City}{SET Place {MERGEFIELD City}}ENTER
ENTER
"}{MERGEFIELD Employee}TAB{MERGEFIELD Sales}ENTER
"}ENTER

The problem with the field code in the KB article is that it inserts an extra line between the records when an Excel workbook is
used as the data source.

--
Cheers
macropod
[MVP - Microsoft Word]


"Glitter" wrote in message ...
My data source has 4 or more rows of data for each record of my mail merge.
How can I set up the mail merge to grab more than 1 row of data (it needs to
be flexible) into 1 mail merged document. For example...

1 Record:
Customer A 123456 Address City State
Customer A 234561 Address City State
Customer A 345612 Address City State

Need it to come onto the letter like:

Customer A Address City State
123456
234561
345612