Creating Address Labels in Excel

[Guest]

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.

 

[David McRitchie]

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

 

[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

 

[Guest]

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

 

[Guest]

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