Print Address Labels from Columns??

[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?

 

[Frank Kabel]

Hi
the following sites may help you using Word in combination with Excel
(mail merge for your labels):
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

 

[Gord Dibben]

Al

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

 

[David McRitchie]

Hi Al,
It is difficult (frustrating) to get Excel by itself to print labels, what might be
set up properly for you may not work for someone else printing to
the same machine.

Microsoft expects you to use MS Word's Mail Merge and you can
use Excel as your database. Some help in doing this can be
found on my Mail Merge page.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm