How do I use Excel to create labels?
 

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

How do I use Excel to create labels?
 

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.


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

How do I use Excel to create labels?
 

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

"willwonka" wrote:

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.


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

How do I use Excel to create labels?
 

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!
================================================== ===

"Heidi Alfred" wrote in message
...
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

"willwonka" wrote:

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.


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

How do I use Excel to create labels?
 

"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

How do I use Excel to create labels?
 

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
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"linda camoriano" <linda wrote in message
...


"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

How do I use Excel to create labels?
 

"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

How do I use Excel to create labels?
 

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

"FannyJ" a écrit dans le message de news:
...


"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

How do I use Excel to create labels?
 

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.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"papou" wrote in message ...
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

"FannyJ" a écrit dans le message de news: ...


"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

How do I use Excel to create labels?
 

"Heidi Alfred" wrote:

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

"willwonka" wrote:

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.


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

How do I use Excel to create labels?
 

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.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

On Mon, 14 Jul 2008 17:54:00 -0700, mailchickie
wrote:



"Heidi Alfred" wrote:

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

"willwonka" wrote:

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.


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

How do I use Excel to create labels?
 

"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

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