 |
 | 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 / April 2008I want to know how to print one full sheet of the same data entry.
I have Office 2007 and I want to know how to print one full sheet of the same data entry, from over 600 entries from an excel file. So, if I have a sheet with 40 labels and I want to print the first entry 40 times on the first sheet and on the next sheet to be the next entry and so on. Thank you. Remove the <<Next Record>> field from all of the labels on the sheet.  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 >I have Office 2007 and I want to know how to print one full sheet of the >same [quoted text clipped - 3 lines] > sheet and on the next sheet to be the next entry and so on. > Thank you. I guess I might have been wrong in my assumption that you already had a mail merge document set up. If you need help with that, see the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_labels_with_word_xp.htm and before executing the merge, delete the <<Next Record>> field from each label on the mail merge main document. 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 >I have Office 2007 and I want to know how to print one full sheet of the >same [quoted text clipped - 3 lines] > sheet and on the next sheet to be the next entry and so on. > Thank you. Christian, 1. Open Word> Select New Document> Labels> Choose the Label you want to use, or create a label yourself. 2. Choose the Data Source and the Recipients that you want to use. The upper left box will be empty, and all other boxes on the page will have the <<NEXT Record>> field inserted. 3. Insert the Mergefields that you want to use in the upper left box, such as: «First_Name» «Last_Name» «Home_Street» «Home_City», «Home_State» «Home_Postal_Code» 4. Copy the Contents of the first box, to Word's clipboard> Highlight the <<Next Record>> field in the other boxes one by one> Paste the contents of the clipboard, to the Cell replacing the <<Next Record>> field, and repeat in next cell one by one. 5. Merge to New Document> Select All Records> Check for errors> Print sheets. 6. Save the original Mail Merge document as a Template for future use. There is probably a way to use Macros to make the copy and paste process faster, and someone with more knowledge can tell you how its done, using different label formats. But my knowledge is limited with their use, so this is the simplest method, I can suggest to you. SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> I have Office 2007 and I want to know how to print one full sheet of the same data entry, from over 600 entries from an excel file. So, if I have a sheet with 40 labels and I want to print the first entry 40 times on the first sheet and on the next sheet to be the next entry and so on. Thank you. There is a button on the user interface for the purpose of propagating the label set up. 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 > Christian, > [quoted text clipped - 40 lines] > sheet and on the next sheet to be the next entry and so on. > Thank you. Doug, I was wondering, how would you use the replace function to remove the <<Next Record>> field that is added when you propagate the document. I have tried: Edit> Select All> Edit> Replace> type both: "<<Next Record>>" & "{Next}" (w/o quotes) for the feature to search for, then left the Replace with box empty. It doesn't remove the <<Next Record>> field from the other labels on the sheet, and I have to manually remove them. Do you have any suggestions? SignatureAdd MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) <message rule> <<Previous Text Snipped to Save Bandwidth When Appropriate>> There is a button on the user interface for the purpose of propagating the label set up. 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 > Christian, > [quoted text clipped - 40 lines] > sheet and on the next sheet to be the next entry and so on. > Thank you. Press Alt + F9 to toggle on the display of the field codes and the use Edit Replace to replace NEXT with nothing. It will leave an empty field in the document but that does not matter. 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 > Doug, > I was wondering, how would you use the replace function to remove the [quoted text clipped - 58 lines] >> sheet and on the next sheet to be the next entry and so on. >> Thank you. Rich, Thank you very much, it works! Unbelievable! Al the best, Christian > Christian, > [quoted text clipped - 35 lines] > sheet and on the next sheet to be the next entry and so on. > Thank you.
|
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.