A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging data from excel into a word table



 
 
Thread Tools Display Modes
  #1  
Old November 24th, 2009, 07:23 AM posted to microsoft.public.word.tables
Lizzle
external usenet poster
 
Posts: 1
Default 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  
Old November 24th, 2009, 10:55 AM posted to microsoft.public.word.tables
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:22 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.