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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can you print labels directly from excel

Status
Not open for further replies.

proudusa

MIS
Joined
Sep 19, 2001
Messages
439
Location
US
Is there a way to print labels in excel when given a spreadsheet with Names in Column A, address in Column B, city in Column C and Zip in column D?

or do you have to export to another program?

Thanks
 
Is there a way to print labels in excel when given a spreadsheet with Names in Column A, address in Column B, city in Column C and Zip in column D?

I think not. But you can do it in Word in two ways: (1) In Word, point to Tools->Letters & Mailings->Envelopes & Labels; or (2) Same in Word, but Mail Merge. In Excel, read your Help file about "Create a Word Mail Merge with Excel Data". This will help you print Labels in Word from an Excel Data.

Peping
 
thanks i'll try the merge over to word. The list had been created by someone in excel.
 
You can create the envelope as a mail merge in Word and then use the Excel spreadsheet as your data source when merging. This would probably be your easiest and best choice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top