Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I 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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
Remove the Next Record field from all of the labels on the sheet.
-- 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 "Christian" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
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_lab...th_word_xp.htm and before executing the merge, delete the Next Record field from each label on the mail merge main document. -- 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 "Christian" wrote in message ... 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. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Christian" wrote in message ... 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. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
There is a button on the user interface for the purpose of propagating the
label set up. -- 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 "Rich/rerat" wrote in message ... 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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Christian" wrote in message ... 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. |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
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? -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... There is a button on the user interface for the purpose of propagating the label set up. -- 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 "Rich/rerat" wrote in message ... 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. "Christian" wrote in message ... 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. |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data entry.
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. -- 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 "Rich/rerat" wrote in message ... 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? -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Doug Robbins - Word MVP" wrote in message ... There is a button on the user interface for the purpose of propagating the label set up. -- 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 "Rich/rerat" wrote in message ... 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. "Christian" wrote in message ... 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. |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I want to know how to print one full sheet of the same data en
Rich,
Thank you very much, it works! Unbelievable! Al the best, Christian "Rich/rerat" wrote: 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. -- Add MS to your News Reader: news://msnews.microsoft.com Rich/rerat (RRR News) message rule Previous Text Snipped to Save Bandwidth When Appropriate "Christian" wrote in message ... 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. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen in print layout doesn't show full sheet size | Microsoft Word Help | |||
how to print the mailmerge data sheet | Microsoft Word Help | |||
how do i change a full word document into 4 on one sheet | Microsoft Word Help | |||
print full sheet of different addresses on labels | Microsoft Word Help | |||
How to print a full sheet of labels for each person on a list | Mailmerge |