View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I use Excel to create labels?

Do you have Word?

Use Word's mailmerge...........labels and envelopes.

Assuming you are using Word for the mailmerge and Excel for the source see
these sites for help on setting up your data input in Excel and how to merge
to Word

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

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Make sure you have a few sheets of sticky labels available for printing.


Gord Dibben MS Excel MVP

On Wed, 17 Sep 2008 16:08:04 -0700, Richard Shumway <Richard
wrote:



"Heidi Alfred" wrote:

Hi,

What I need to do is take addresses from the yellow pages and create a
database in Excel. Then I have to make mailing labels with them. How do I
set up the Excel page to put the addresses in so that they will print on a
label? I would appricieate any assistance I can get.

Thank you
Heidi