software

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.Hi Mandy,
If you have Microsoft Office then you would use Microsoft Word to
do the printing with Excel as the database.
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.
www.mvps.org/dmcritchie/excel/snakecol.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Mandy Banksquot; lt;Mandy gt; wrote in message ...
gt; I have maintained my greeting card mailing list for years in a non-Microsoft
gt; program. After I changed my OS to Windows XP, the mailing program wouldn't
gt; work.
gt;
gt; I recently managed to pull the name and address data into Excel, but can't
gt; figure out how to create mailing labels from the data. Is there a way to
gt; create mailing labels in Excel without having to merge the data with Word or
gt; another program?
gt;
gt; Thanks very much for pointing me in a direction.
gt;
Mandy, Here's a way from John Walkenbach just using excel, although I think
using word to do the merge would be better

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 amp; 2003

quot;Mandy Banksquot; lt;Mandy gt; wrote in message
...
gt; I have maintained my greeting card mailing list for years in a
non-Microsoft
gt; program. After I changed my OS to Windows XP, the mailing program
wouldn't
gt; work.
gt;
gt; I recently managed to pull the name and address data into Excel, but can't
gt; figure out how to create mailing labels from the data. Is there a way to
gt; create mailing labels in Excel without having to merge the data with Word
or
gt; another program?
gt;
gt; Thanks very much for pointing me in a direction.
gt;
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

quot;David McRitchiequot; wrote:

gt; Hi Mandy,
gt; If you have Microsoft Office then you would use Microsoft Word to
gt; do the printing with Excel as the database.
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt;
gt; If your data is all in one column then you would first have to prepare you
gt; Excel data so that each recipient is on one row.
gt; www.mvps.org/dmcritchie/excel/snakecol.htm
gt;
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;Mandy Banksquot; lt;Mandy gt; wrote in message ...
gt; gt; I have maintained my greeting card mailing list for years in a non-Microsoft
gt; gt; program. After I changed my OS to Windows XP, the mailing program wouldn't
gt; gt; work.
gt; gt;
gt; gt; I recently managed to pull the name and address data into Excel, but can't
gt; gt; figure out how to create mailing labels from the data. Is there a way to
gt; gt; create mailing labels in Excel without having to merge the data with Word or
gt; gt; another program?
gt; gt;
gt; gt; Thanks very much for pointing me in a direction.
gt; gt;
gt;
gt;
gt;

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

quot;Paul Bquot; wrote:

gt; Mandy, Here's a way from John Walkenbach just using excel, although I think
gt; using word to do the merge would be better
gt;
gt; www.j-walk.com/ss/excel/tips/tip92.htm
gt;
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Mandy Banksquot; lt;Mandy gt; wrote in message
gt; ...
gt; gt; I have maintained my greeting card mailing list for years in a
gt; non-Microsoft
gt; gt; program. After I changed my OS to Windows XP, the mailing program
gt; wouldn't
gt; gt; work.
gt; gt;
gt; gt; I recently managed to pull the name and address data into Excel, but can't
gt; gt; figure out how to create mailing labels from the data. Is there a way to
gt; gt; create mailing labels in Excel without having to merge the data with Word
gt; or
gt; gt; another program?
gt; gt;
gt; gt; Thanks very much for pointing me in a direction.
gt; gt;
gt;
gt;
gt;