Creating Address Labels in Excel

M

Mandy Banks

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.
 
P

Paul B

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
 
M

Mandy Banks

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 said:
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 said:
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.
Click to expand...
Click to expand...
 
M

Mandy Banks

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
 
Top