How can I get different names on each label?

[Guest]

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!

 

[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

 

[Guest]

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.

 

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

 

[Guest]

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

 

[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).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Beth Melton]

You're welcome. Glad to hear you're back in business.

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/