Merge multiple records into the same document?

Howdy,

I can do normal mail merges just fine but was posed this question today
which I don't know the answer to.

This is office 2k7.

We have a Word document. In the middle of that document, we want to put in
a small table that will pull data from a spreadsheet. We will do the merge
and select just the rows that we want, but need all the info from those rows
to merge into the same spreadsheet area in the same document and not to
create multiple documents each with one row of data like a normal merge.

Does that make sense?

Can this be done?

Thanks.

You can possibly make use of a Database field or see fellow MVP Macropod's
"Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:

http://www.wopr.com/index.php?showtopic=731107

or

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com
"Mr B" wrote in message
...
Howdy,

I can do normal mail merges just fine but was posed this question today
which I don't know the answer to.

This is office 2k7.

We have a Word document. In the middle of that document, we want to put
in
a small table that will pull data from a spreadsheet. We will do the
merge
and select just the rows that we want, but need all the info from those
rows
to merge into the same spreadsheet area in the same document and not to
create multiple documents each with one row of data like a normal merge.

Does that make sense?

Can this be done?

Thanks.