Addresses: printing or exporting to word?

J

Jamie K.

I'd like to input snail mail addresses into Excel. The end result would be
to print them to mailing labels. Is there an easy way to do this within
Excel, or is there a way to export to Word and take care of the printing
from there? Open to other options, too.

Thanks.

Jamie
OS 10.3, Excel X
 
J

JE McGimpsey

Jamie K. said:
I'd like to input snail mail addresses into Excel. The end result would be
to print them to mailing labels. Is there an easy way to do this within
Excel, or is there a way to export to Word and take care of the printing
from there? Open to other options, too.
Click to expand...

this is a comman usage of XL - make each row a record containing your
names, and addresses. Put a header in each column.

Then use Word's Data Merge Manager to create mailing labels. No
exporting necessary - Word can use the XL workbook as a data source.

See Word Help for details.
 
J

Jamie K.

Thanks! I'll give it a try.

this is a comman usage of XL - make each row a record containing your
names, and addresses. Put a header in each column.

Then use Word's Data Merge Manager to create mailing labels. No
exporting necessary - Word can use the XL workbook as a data source.

See Word Help for details.
Click to expand...
 
Top