Can I print mail out labels or envelopes using data in excell

[Guest]

I need to print labels or envelopes using names and addresses setup in excell
with Line 2 having name in colum A, address colum B, city and state colum C
and zip code colum D. Then line 2 would have a different name,address etc.
etc. Looking for the least time consuming way to use this data to print
labels or envelopes to mail out information. Is there any way to print this
from excell data or convert to a printable file?

 

[Trevor Shuttleworth]

Use Mail Merge in Word and select the Excel spreadsheet as the data source.

Regards

Trevor

 

[Gord Dibben]

cocoa

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Gord Dibben MS Excel MVP

I need to print labels or envelopes using names and addresses setup in excell
with Line 2 having name in colum A, address colum B, city and state colum C
and zip code colum D. Then line 2 would have a different name,address etc.
etc. Looking for the least time consuming way to use this data to print
labels or envelopes to mail out information. Is there any way to print this
from excell data or convert to a printable file?

Gord Dibben MS Excel MVP

 

[Guest]

It worked great. Thank you sooooooooo much! You do not Know how much I
appreciate the response.

 

[Guest]

Thank You sooooooooo Much. It worked great. You do not know how much I
appreciate the response.

 

[Trevor Shuttleworth]

you're welcome ... thanks for the feedback, glad I could help