How do I use Excel to create labels?

[Guest]

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

 

[willwonka]

The only thing that I have done is to put the data in Excel and then I
used Word to print the lables using my Excel spreadsheet as the source.

Within Word, you go to Tools.. Letters and Mailings..Envelopes and
Labels .. and follow the wizard from there.

As I remember, the only glitch here is that you need to have your data
on the first tab of the spreadsheet.

Hope this helps.

 

[Guest]

Thank you...Is there a certain way or format that I have to use to put the
info into excel in order for it merge correctly?

Heidi

 

[RagDyeR]

Check out these links:

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

And

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

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Thank you...Is there a certain way or format that I have to use to put the
info into excel in order for it merge correctly?

Heidi

 

[Guest]

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

 

[David McRitchie]

You can't really print labels in Excel, instead you use
Excel as the database and use MS Word for the label
printing since Word handles label forms.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[Guest]

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

 

[papou]

Hello
I suggest you keep Excel for your database and use Word for your labels as
it has a built-in function provided for printing labels.
See also help on MailMerge in Word.

HTH
Cordially
Pascal

 

[David McRitchie]

I can only see part of this thread but take a look at
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
for printing labels with MS Word, with Excel as the data base.

Excel not very well suited to printing labels.

 

[mailchickie]

Thank you...Is there a certain way or format that I have to use to put the
info into excel in order for it merge correctly?

Heidi

 

[Gord Dibben]

Elements of the addresses go into separate columns with a title like

Name Address City State Zip

See these sites for help.

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

Note.........if you give your table a defined name you don't have to have the
worksheet first in the workbook.


Gord Dibben MS Excel MVP

 

[Richard Shumway]

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

 

[Gord Dibben]

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/MailMerge/CreateAMailMerge.htm

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

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


Gord Dibben MS Excel MVP