| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
take names and address in excel and move to mailing labels
We would like to take names and address that are in an excel document and
move to mailing labels. What steps do we take to do this? I do not work a lot with the excel program. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
take names and address in excel and move to mailing labels
The easiest way to do this is a Data Merge in Word, using the XL
workbook as the data source. See the "Create labels by using the Data Merge Manager" topic in Word Help for more. In article , RJKloste wrote: We would like to take names and address that are in an excel document and move to mailing labels. What steps do we take to do this? I do not work a lot with the excel program. Any help would be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
take names and address in excel and move to mailing labels
Excel alone is poorly suited for this task.
Word is much better for labels using Excel as the source for the labels. Assuming you are using Word for the mailmerge and Excel for the source 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 Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 07:00:05 -0700, RJKloste wrote: We would like to take names and address that are in an excel document and move to mailing labels. What steps do we take to do this? I do not work a lot with the excel program. Any help would be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
take names and address in excel and move to mailing labels
As an FYI, the Avery Dennison folks have a utility that reads an Excel file
and prints labels - the only caveat is that the file can be only one worksheet. See http://www.avery.com/us/Main?action=...twarecode=3201 HTH Steve "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Excel alone is poorly suited for this task. Word is much better for labels using Excel as the source for the labels. Assuming you are using Word for the mailmerge and Excel for the source 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 Gord Dibben MS Excel MVP On Wed, 26 Sep 2007 07:00:05 -0700, RJKloste wrote: We would like to take names and address that are in an excel document and move to mailing labels. What steps do we take to do this? I do not work a lot with the excel program. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Mailing labels...already have full address in each cell | Excel Discussion (Misc queries) | |||
| How do I make a address book for mailing labels | New Users to Excel | |||
| How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
| How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
| how do i convert MS Word mailing labels into an Excel mailing lis. | Excel Discussion (Misc queries) | |||
Linear Mode
