Why do I get <Next Record> as my label when using Mail Merge?

[jim zuber]

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?

 

[Peter Jamieson]

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.

 

[Rich/rerat]

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>>


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?

 

[Graham Mayor]

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>