Hi - I created a mail merge document a while ago and all was well. I now
want to print out the database so I can keep better track of the people I
sent the document to, but I can't seem to figure out how to do that. Online
help doesn't seem to cover this. Does anyone know how to do it? Basically,
I'd like a spreadsheet view of the database I entered. Thx.

Create a "spreadsheet table" in a Word document that is only ONE page. Put
your headers in it and everything. Put merge fields in the first row. Copy
the first row and paste to create the 2nd row. Place your cursor in front of
the FIRST merge field (to the left of it) and insert a next record Word
field. Copy row 2 and paste below row 2 until you have a full page.
Run your merge.
See the first image at:
http://www.officearticles.com/word/t...oft_word. htm
When you want the next record, you must have the next record field. You will
only have one next record for each row, unlike the labels in the image.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"klfb" wrote in message
...
Hi - I created a mail merge document a while ago and all was well. I now
want to print out the database so I can keep better track of the people I
sent the document to, but I can't seem to figure out how to do that.
Online
help doesn't seem to cover this. Does anyone know how to do it?
Basically,
I'd like a spreadsheet view of the database I entered. Thx.

Use a Directory type mailmerge main document to which you attach the same
data source and in which you have a one row table into the cells of which
you insert the merge fields. When you execute that merge to a new document,
it will contain a table with one row of data for each record in the data
source.

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

"klfb" wrote in message
...
Hi - I created a mail merge document a while ago and all was well. I now
want to print out the database so I can keep better track of the people I
sent the document to, but I can't seem to figure out how to do that.
Online
help doesn't seem to cover this. Does anyone know how to do it?
Basically,
I'd like a spreadsheet view of the database I entered. Thx.

That is NOT the easiest way to do it.

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

"Anne Troy" wrote in message
...
Create a "spreadsheet table" in a Word document that is only ONE page. Put
your headers in it and everything. Put merge fields in the first row. Copy
the first row and paste to create the 2nd row. Place your cursor in front
of the FIRST merge field (to the left of it) and insert a next record Word
field. Copy row 2 and paste below row 2 until you have a full page.
Run your merge.
See the first image at:
http://www.officearticles.com/word/t...oft_word. htm
When you want the next record, you must have the next record field. You
will only have one next record for each row, unlike the labels in the
image.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"klfb" wrote in message
...
Hi - I created a mail merge document a while ago and all was well. I now
want to print out the database so I can keep better track of the people I
sent the document to, but I can't seem to figure out how to do that.
Online
help doesn't seem to cover this. Does anyone know how to do it?
Basically,
I'd like a spreadsheet view of the database I entered. Thx.

I stand corrected.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Doug Robbins - Word MVP" wrote in message
...
That is NOT the easiest way to do it.

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

"Anne Troy" wrote in message
...
Create a "spreadsheet table" in a Word document that is only ONE page.
Put your headers in it and everything. Put merge fields in the first row.
Copy the first row and paste to create the 2nd row. Place your cursor in
front of the FIRST merge field (to the left of it) and insert a next
record Word field. Copy row 2 and paste below row 2 until you have a full
page.
Run your merge.
See the first image at:
http://www.officearticles.com/word/t...oft_word. htm
When you want the next record, you must have the next record field. You
will only have one next record for each row, unlike the labels in the
image.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"klfb" wrote in message
...
Hi - I created a mail merge document a while ago and all was well. I
now
want to print out the database so I can keep better track of the people
I
sent the document to, but I can't seem to figure out how to do that.
Online
help doesn't seem to cover this. Does anyone know how to do it?
Basically,
I'd like a spreadsheet view of the database I entered. Thx.

Thank you very much for you help. I did as you instructed and was able to
get the data in the format I wanted. I appreciate your assistance! - klfb

"Doug Robbins - Word MVP" wrote:

Use a Directory type mailmerge main document to which you attach the same
data source and in which you have a one row table into the cells of which
you insert the merge fields. When you execute that merge to a new document,
it will contain a table with one row of data for each record in the data
source.

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

"klfb" wrote in message
...
Hi - I created a mail merge document a while ago and all was well. I now
want to print out the database so I can keep better track of the people I
sent the document to, but I can't seem to figure out how to do that.
Online
help doesn't seem to cover this. Does anyone know how to do it?
Basically,
I'd like a spreadsheet view of the database I entered. Thx.