I am using Office 2000, and I'm trying to import excel data into word as
labels. I have one column of numbers(approx. 350 cells) I would like to
import into Word as individual labels. can this be done?
--
Trial and Error takes too long!

Use Mail merge. :)
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"wichita6" wrote in message
...
I am using Office 2000, and I'm trying to import excel data into word as
labels. I have one column of numbers(approx. 350 cells) I would like to
import into Word as individual labels. can this be done?
--
Trial and Error takes too long!

use Mail Merge, I've not actually done what you asked for on a PC,
but if you can't figure it out using Anne's directions or mine at
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
post back. You may have some unique problems, but you probably
already have the label stock that you want to use. .

If you are labelling cables, you might want to print the number
across the label several times (possibly 8 times if short numbers) per label
then you can tear the label by hand and wrap one half on each
end of the cable -- or use one label per end depends on size of label
and what is written on it. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"wichita6" wrote in message ...
I am using Office 2000, and I'm trying to import excel data into word as
labels. I have one column of numbers(approx. 350 cells) I would like to
import into Word as individual labels. can this be done?
--
Trial and Error takes too long!

Hi,
This worked great. Thank you for your fast reply!

--
Trial and Error takes too long!


"David McRitchie" wrote:

use Mail Merge, I've not actually done what you asked for on a PC,
but if you can't figure it out using Anne's directions or mine at
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
post back. You may have some unique problems, but you probably
already have the label stock that you want to use. .

If you are labelling cables, you might want to print the number
across the label several times (possibly 8 times if short numbers) per label
then you can tear the label by hand and wrap one half on each
end of the cable -- or use one label per end depends on size of label
and what is written on it. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"wichita6" wrote in message ...
I am using Office 2000, and I'm trying to import excel data into word as
labels. I have one column of numbers(approx. 350 cells) I would like to
import into Word as individual labels. can this be done?
--
Trial and Error takes too long!