Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Address Labels in Excel
I have maintained my greeting card mailing list for years in a non-Microsoft
program. After I changed my OS to Windows XP, the mailing program wouldn't work. I recently managed to pull the name and address data into Excel, but can't figure out how to create mailing labels from the data. Is there a way to create mailing labels in Excel without having to merge the data with Word or another program? Thanks very much for pointing me in a direction. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Address Labels in Excel
Mandy, Here's a way from John Walkenbach just using excel, although I think
using word to do the merge would be better http://www.j-walk.com/ss/excel/tips/tip92.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mandy Banks" <Mandy wrote in message ... I have maintained my greeting card mailing list for years in a non-Microsoft program. After I changed my OS to Windows XP, the mailing program wouldn't work. I recently managed to pull the name and address data into Excel, but can't figure out how to create mailing labels from the data. Is there a way to create mailing labels in Excel without having to merge the data with Word or another program? Thanks very much for pointing me in a direction. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Address Labels in Excel
Thank you very much for your speedy assistance. I'll give it a try.
Meanwhile, I'm wondering if it would be easier to just start over by creating my mailing list in Access... Mandy "David McRitchie" wrote: Hi Mandy, If you have Microsoft Office then you would use Microsoft Word to do the printing with Excel as the database. http://www.mvps.org/dmcritchie/excel/mailmerg.htm If your data is all in one column then you would first have to prepare you Excel data so that each recipient is on one row. http://www.mvps.org/dmcritchie/excel/snakecol.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Mandy Banks" <Mandy wrote in message ... I have maintained my greeting card mailing list for years in a non-Microsoft program. After I changed my OS to Windows XP, the mailing program wouldn't work. I recently managed to pull the name and address data into Excel, but can't figure out how to create mailing labels from the data. Is there a way to create mailing labels in Excel without having to merge the data with Word or another program? Thanks very much for pointing me in a direction. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating Address Labels in Excel
I appreciate having your help -- and John's. Being a novice at using Excel,
I'm beginning to think that using Access might be a better bet for me. Happy new year! Mandy "Paul B" wrote: Mandy, Here's a way from John Walkenbach just using excel, although I think using word to do the merge would be better http://www.j-walk.com/ss/excel/tips/tip92.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Mandy Banks" <Mandy wrote in message ... I have maintained my greeting card mailing list for years in a non-Microsoft program. After I changed my OS to Windows XP, the mailing program wouldn't work. I recently managed to pull the name and address data into Excel, but can't figure out how to create mailing labels from the data. Is there a way to create mailing labels in Excel without having to merge the data with Word or another program? Thanks very much for pointing me in a direction. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel email address hyperlink does not update | Excel Discussion (Misc queries) | |||
Creating forms in excel | Excel Discussion (Misc queries) | |||
HOW DO I TRANSFER MY ADDRESS BOOK FROM MICROSOFT EXCEL TO PALM DE. | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
How do I print onto Labels in Excel | Setting up and Configuration of Excel |