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.

Creating Address Labels in Excel
 

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.

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.

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.

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.