Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create excel spreadsheet on a data access page | Excel Discussion (Misc queries) | |||
Can I use Excel to create this text file? | Excel Worksheet Functions | |||
Create random number bingo cards with Excel | New Users to Excel | |||
How do I create a column label in Excel? | New Users to Excel | |||
Excel should let me align data labels in different series (Excel . | Charts and Charting in Excel |