If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging data from excel into a word table
I have been working with data that has been brought into an Excel spreadsheet
and then into a Word table - almost like a label format only the same information is needed in the two labels on each row (creating exhibit tickets for a show) - the whole thing seemed to work fine except that I found (unfortunately too late) that every 6th record was not being printed (5 to a page) - I have tried several different formats using less on the page but no matter what I do I am always a record missing between pages. Any help or suggestions would be appreciated. |
#2
|
|||
|
|||
Merging data from excel into a word table
To get your five pairs of labels to a page, you need a Next Record field
before the first merge field in the first column of the second through the fifth rows only. It sounds like you have it either before the first mergefield in the first column of the first row, or you have it after the last mergefield in the second column of all of the rows. -- 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, originally posted via msnews.microsoft.com "Lizzle" wrote in message ... I have been working with data that has been brought into an Excel spreadsheet and then into a Word table - almost like a label format only the same information is needed in the two labels on each row (creating exhibit tickets for a show) - the whole thing seemed to work fine except that I found (unfortunately too late) that every 6th record was not being printed (5 to a page) - I have tried several different formats using less on the page but no matter what I do I am always a record missing between pages. Any help or suggestions would be appreciated. |
Thread Tools | |
Display Modes | |
|
|