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 » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Too many labels generated



 
 
Thread Tools Display Modes
  #1  
Old August 10th, 2009, 07:22 PM posted to microsoft.public.word.mailmerge.fields
Mark Eckstein
external usenet poster
 
Posts: 2
Default Too many labels generated

In Word 2003 or 2007, when I merge an Excel .xls spreadsheet into mailing
labels, I get far too many labels. On the first page of labels, I get Records
1-30; on the second page pf labels, I get Records 2-31, etc., until I get to
the last page, which only has the last record on it.

I know this must be a simple fix, but I am unable to discern my error. I
think I have been following the directions meticulously, but obviously not.
Any help would be greatly appreciated.
  #2  
Old August 10th, 2009, 10:25 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Too many labels generated

I am not sure how you created the mail merge main document, but normally it
would have had a Next Record field before the first merge field on all of
the labels on the sheet except for the first label. You can manually insert
such a field via the Rules icon in Word 2007 or, if I remember correctly via
the Insert Word Fields item in Word 2003.

It might however be quicker to just start again.

See the following articles on fellow MVP Graham Mayor’s website:

http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

or

http://www.gmayor.com/merge_labels_with_word_2007.htm


--
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
"Mark Eckstein" wrote in message
...
In Word 2003 or 2007, when I merge an Excel .xls spreadsheet into mailing
labels, I get far too many labels. On the first page of labels, I get
Records
1-30; on the second page pf labels, I get Records 2-31, etc., until I get
to
the last page, which only has the last record on it.

I know this must be a simple fix, but I am unable to discern my error. I
think I have been following the directions meticulously, but obviously
not.
Any help would be greatly appreciated.


  #3  
Old August 11th, 2009, 06:28 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Too many labels generated

It sounds as though you are printing labels from the label preview rather
than completing the merge either to a new document or to the printer.
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mark Eckstein wrote:
In Word 2003 or 2007, when I merge an Excel .xls spreadsheet into
mailing labels, I get far too many labels. On the first page of
labels, I get Records 1-30; on the second page pf labels, I get
Records 2-31, etc., until I get to the last page, which only has the
last record on it.

I know this must be a simple fix, but I am unable to discern my
error. I think I have been following the directions meticulously,
but obviously not. Any help would be greatly appreciated.



  #4  
Old August 11th, 2009, 09:31 PM posted to microsoft.public.word.mailmerge.fields
Mark Eckstein
external usenet poster
 
Posts: 2
Default Too many labels generated

Doug, Graham, thanks so much for your quick responses!

It was, of course, a simple fix. Doug, your information confirmed that I
was doing everything else correctly. Graham, you were right--I was looking
at the label preview. When I actually generated the labels, all was correct.


Thaks again to both of you.

"Mark Eckstein" wrote:

In Word 2003 or 2007, when I merge an Excel .xls spreadsheet into mailing
labels, I get far too many labels. On the first page of labels, I get Records
1-30; on the second page pf labels, I get Records 2-31, etc., until I get to
the last page, which only has the last record on it.

I know this must be a simple fix, but I am unable to discern my error. I
think I have been following the directions meticulously, but obviously not.
Any help would be greatly 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 10:56 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.