Word 2000 labels to MS Excel 2000

[Donna]

I have a document in word setup as Avery 5160 label format. How to I import
that into Excel using Excel 2000 or older version. I have XP so cannot match
instructions to the person I'm trying to explain this to.

Any immediate help greatly appreciated, he's breathing down my back as we
speak.

 

[dlw]

Excel 2000 doesn't really do labels by itself, you are supposed to use it for
the data file part of a merge in Word. Your Word document, is it a mail
merge document, with field names and a data file? Do you want them to have
labels, or are you trying to get the data to them?

 

[Dave Peterson]

You may find using MSWord and its builtin mailmerge easier. It supports lots of
different forms (Avery standard forms???) that might make it easier.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And just in case you have text that needs to be formatted (percentages, for
example):

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg>.)

 

[Donna]

My client needs to have the labels in spreadsheet format for a printer to
print postcards for him. why the printer doesn't know how to convert the
data I don't know, but I need the labels in .xls format.

 

[Peo Sjoblom]

You should really explain to him that nobody in his/her right mind uses
Excel for this. Excel is the data source while Word use it's built in
capabilities. While there might be somebody who has done this you are
probably lucky to find him/her given that you are in a hurry



--


Regards,


Peo Sjoblom

 

[Bob I]

Maybe the printer is going to use merge to print the lables. I suggest
the "client" request the excel template from the printer so you may
format the addresses properly. Without that who knows what the printer
wants.