View Single Post
  #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?