Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to print labels from excel 1

Status
Not open for further replies.

Rinnt

MIS
Feb 11, 2002
181
US
Does anyone know how to print labels from Excel '97?
 
Just in Excel?...or do you mean to say, merge a word doc to an excel speadsheet?
 
No just from Excel. There is data in excel that could be printed as labels. Preferable on a cell by cell basis...
 
You would have to (painfully) set that up with code...it would be much easier and faster if you had Word and linked it to your spreadsheet.
 
This may help: In Excel 2002/XP help, I put in this phrase: Create a Word mail merge with Excel data.

It gives steps on how to do it. I just did a spreadsheet containing names and addresses, worked like a charm. A big key is having no blank rows or columns, blank cells okay, as is having First name, Last name, Address, City, State, and Zip Code as column headers. Did have a little problem getting the Zip Code column to be complete but copying the column and then pasting it in the Word document worked.

Save the file with a new name and where you can find it.
 
could you import the data into a table in access and run the label wizard?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top