View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default 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.