Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Printing a table of the mail merge database
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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help troubleshooting printing of mail merge labels. | New Users | |||
Mail merge macro does not find database query | Mailmerge | |||
Mail merge fields not visible but printing | Mailmerge | |||
Convert Table Labels to do Mail Merge? | Mailmerge | |||
Word mail merge doesn't pick up the addresses in Access database. | Tables |