Excel to Word
 

I have just completed a userform with tons of fields. Once submitted it
places the data into the worksheet. The worksheet itself has 141 columns of
different values. Now I need to have some sort of code that fits into a
command button from the toolbox on the actual worksheet to transfer data form
each row that has data into a word document. Each row has to be it's own
paragraph. Is this possible? A short sample of the data layout:

Column Headers:
ID Description Total Location Date Coats
Labor (hrs)
20 Room Painted $500.00 Living Room 9/17/05 3 5
30 Room 2 Paint $600.00 Bath 9/20/05 2 2

I would love it to be in word in the following format:

ID: 20, Description: Room Painted, Total: $500.00, Location: Living Room,
Date: 9/17/05, Coats: 3, Labor (hrs): 5

ID: 30, Description: Room 2 Paint, Total: $600.00, Location: Bath, Date:
9/20/05, Coats: 2, Labor (hrs): 2

Basically it would continue until it reached a row with no data. Can this be
done? Thanks in advance!!

-----Original Message-----
I have just completed a userform with tons of fields.
Once submitted it
places the data into the worksheet. The worksheet itself
has 141 columns of
different values. Now I need to have some sort of code
that fits into a
command button from the toolbox on the actual worksheet
to transfer data form
each row that has data into a word document. Each row has
to be it's own
paragraph. Is this possible? A short sample of the data
layout:
hAVE YOU CONSIDERED A STRAIGHT FORWARD MAIL MERGE
Column Headers:
ID Description Total
Location Date Coats
Labor (hrs)
20 Room Painted $500.00 Living Room
9/17/05 3 5
30 Room 2 Paint $600.00 Bath
9/20/05 2 2

I would love it to be in word in the following format:

ID: 20, Description: Room Painted, Total: $500.00,
Location: Living Room,
Date: 9/17/05, Coats: 3, Labor (hrs): 5

ID: 30, Description: Room 2 Paint, Total: $600.00,
Location: Bath, Date:
9/20/05, Coats: 2, Labor (hrs): 2

Basically it would continue until it reached a row with
no data. Can this be
done? Thanks in advance!!

.