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.
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
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
>
>
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Heidi Alfred" <HeidiAlfred@discussions.microsoft.com> wrote in message
news:BD9A1B6B-BD8D-4372-9AE5-3DBE19D1DE30@microsoft.com...
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
>
>
> 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
> >
> >
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
<mailchickie@discussions.microsoft.com> 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
>> >
>> >
> 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
"linda camoriano" <linda camoriano@discussions.microsoft.com> wrote in message
news:B9CE0E78-D2CC-4B46-BDAA-5311EFCD1B32@microsoft.com...
>
>
> "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
> 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
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" <FannyJ@discussions.microsoft.com> a écrit dans le message de news:
C5185D4A-5CD9-479B-8341-97DB8A0AD235@microsoft.com...
>
>
> "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
"papou" <cpapoupasbon@çanonpluslaposte.net> wrote in message news:uuMhz60BIHA.3864@TK2MSFTNGP06.phx.gbl...
> 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" <FannyJ@discussions.microsoft.com> a écrit dans le message de news: C5185D4A-5CD9-479B-8341-97DB8A0AD235@microsoft.com...
>>
>>
>> "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
>
>
> 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
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
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
Shumway@discussions.microsoft.com> 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
Question
Reply
Top
Answer
Notify me of replies