making labels in exel 2000

N

nikki

I'm trying to take a chart that was made in Excel 2000 and
turn it into labels on Word 2000. However, when I get to
step three in Mail Wizard and attempt open up the Excel
file, Excel is not listed in the available files. Is there
a way that I can turn my excel spreadsheet into labels or
do I have to start all over and retype them into the label
maker on Word? Please help me out with this issue. Thank
very much and good day.
 
F

Frank Stone

yes. you can send your xl labels direct to the printer. it
might take you a little work to get it right but our
shipping dept does it.
 
G

Gord Dibben

nikki

"Excel is not listed" means what?

You cannot browse to an Excel file and use it?

You have no ODBC driver for Excel?

If the latter, you may have to re-configure and add that driver.

Go to Control Panel(Start>Settings>Control Panel) and double-click on Data
Sources(ODBC).

In User DSN what do you see for drivers?

If no Excel, click on Add and find Excel on the list(not Excel do). Select
and "Finish".

Now enter "Excel Files"(no quotes) in the Data Source dialog.

Ok and Apply your way out.

Gord Dibben Excel MVP
 
D

Debra Dalgleish

You should be opening the Excel file in step two of the Mail Merge Wizard --

In step two (Data Source), click the Get Data button, and
choose 'Open Data Source'
At the bottom of the Open dialog box, from the Files of Type
dropdown, choose 'MS Excel Worksheets (*.xls)
Then you should see the Excel files, and you can select the on
that has the label info

David McRitchie has instructions for mail merge on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also, there's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm
 
Top