Print Address Labels

[Al Franz]

Have an Excel spreadsheet with Name, Address, State, Zip in different
columns. Are there stored functions an easy method to print envelopes or at
least write that information to a text file for printing as address labels?

 

[Gord Dibben]

Al

Are you attempting to make labels directly in Excel?

It could be done in Excel only, but........

Investigate the use of Word's mailmerge feature to get Excel data to labels
and envelopes.

Doing it strictly in Excel is difficult and involves much trial and error
formatting.

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

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

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm

Gord Dibben Excel MVP