[Christian]

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.