Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jim zuber jim zuber is offline
external usenet poster
 
Posts: 1
Default Why do I get Next Record as my label when using Mail Merge?

I'm using an EXCEL file with Word 2003 Mail Merge to create labels. When I
open my 3 column spreadsheet, everything looks good. Then when it loads into
the word document, the area where the first label would appear is blank,
while the remaining fields on sheet have "Next Record" as the label. What
am I doing wrong?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Why do I get Next Record as my label when using Mail Merge?

You aren't doing anything wrong at all. But Word expects you to tell it what
fields in your data source you want to appear in each label. Word does not
try to guess what you want, oor which fields in your data source it should
use.

So...

Insert the fields you need into the /first/ label in your layout.

Use the Propagate labels facility (I leave you to find it) to copy the
fields you inserted to each label in your layout.

Each label except the first should have Next record at the beginning.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"jim zuber" jim wrote in message
...
I'm using an EXCEL file with Word 2003 Mail Merge to create labels. When
I
open my 3 column spreadsheet, everything looks good. Then when it loads
into
the word document, the area where the first label would appear is blank,
while the remaining fields on sheet have "Next Record" as the label.
What
am I doing wrong?


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Rich/rerat Rich/rerat is offline
external usenet poster
 
Posts: 93
Default Why do I get Next Record as my label when using Mail Merge?

jim zuber,
The first label is where you create the way your labels will look like. Once
you are satisfied with the look of the label. On the Mail Merge toolbar,
there should be a button to Propagate the rest of the labels based on the
first label. Once that is done you should Merge to New Document, and review
how the labels will be printed. Then you can print from the document you
created after the merge, if you are satisfied with the results. If not, you
can go back to the original document, change the first label, then Propagate
the Label information again, Merge to New Document, and check the results,
and Print when ready.

--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate


"jim zuber" jim wrote in message
...
I'm using an EXCEL file with Word 2003 Mail Merge to create labels. When I
open my 3 column spreadsheet, everything looks good. Then when it loads
into
the word document, the area where the first label would appear is blank,
while the remaining fields on sheet have "Next Record" as the label. What
am I doing wrong?


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Why do I get Next Record as my label when using Mail Merge?

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

--

Graham Mayor - Word MVP

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


jim zuber wrote:
I'm using an EXCEL file with Word 2003 Mail Merge to create labels.
When I open my 3 column spreadsheet, everything looks good. Then
when it loads into the word document, the area where the first label
would appear is blank, while the remaining fields on sheet have
"Next Record" as the label. What am I doing wrong?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge label only puts one label per page? Ebb Berry Mailmerge 4 April 21st 23 12:06 PM
How do you save a mail merge label document as JUST a label doc? GailD Mailmerge 3 March 29th 06 06:52 PM
Why does Label Mail Merge skip first record on subsequent pages George Mailmerge 3 January 6th 06 05:59 AM
sort mail merge by merge record number nathan Mailmerge 1 August 10th 05 07:09 AM
label merge only 1st record is merging-rest of source won't merge harriet Mailmerge 2 March 29th 05 04:26 PM


All times are GMT +1. The time now is 02:13 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"