How can I get different names on each label?

A

A Treacy

I have tried creating labels using Publisher and also Word by merging my data
from Excel. Each time I get a page of 30 of the same name instead of 30
different names. I saw all 30 names the same on the print preview but tested
by printing as someone suggested and I still got 30 of the same name on each
page. HELP!
 
K

Kate G.

Are you doing a MAIL MERGE ... or using the Envelopes and Labels option on
your Tools menu?

You must use the Mail Merge function in order to pull your data from an
Excel file.

Are you saying that in Print Preview your document displays with the 30
different names... but prints with all the same?

Kathryn Groves
 
A

A Treacy

I was using the mail merge function in Word.
The print preview showed 30 of the same name but someone had suggested that
the names would be correct when printed as this was a software glitch. I
still got 30 of the same name as shown.
 
B

Beth Melton

More than likely the <Next Record> field wasn't added. If you could tell us
which version of Word you are using we could tell you how to fix it. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Co-author of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
A

A Treacy

Thanks so much. You were right about the next record field. That did the trick!
I'm so impressed with this discussiongroup! Mahalo from Hawaii
 
S

Suzanne S. Barnhill

Another possibility is that you have merely propagated the label and not
completed the merge. You must choose Merge to New Document or Merge to
Printer (or E-Mail or Fax).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Help 1
How can the font and size of (all) citation numbers be altered? 1
Grouping Names in Mail Merge 0
Page numbering with Merged Document and IF statements 1
Mail Merge Makes One Page of One Name of One Label Instead 1
how do i change text on single address labels to multi addres lab. 1
Images are pixelated when saving to PDF 0
batch print some specific pages in multiple word files 1

Top