 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / January 2006Printing 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. 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/troubleshoot_mail_merge_results_in_microsoft_ 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 > 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 [quoted text clipped - 3 lines] > Basically, > I'd like a spreadsheet view of the database I entered. Thx. That is NOT the easiest way to do it.  SignatureHope 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 > 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 [quoted text clipped - 19 lines] >> Basically, >> I'd like a spreadsheet view of the database I entered. Thx. I stand corrected. :) ************ Hope it helps! Anne Troy www.OfficeArticles.com > That is NOT the easiest way to do it. > [quoted text clipped - 24 lines] >>> 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. SignatureHope 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 > 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 [quoted text clipped - 3 lines] > 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 > 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 [quoted text clipped - 9 lines] > > Basically, > > I'd like a spreadsheet view of the database I entered. Thx. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.