Getting data to Microsoft Word
 

I am trying to create a command button that will send rows of data to Word
from Excel. Let me give you what the spreadsheet looks like:

1) This is a fixed row (Row 6) and below are the captions in those rows
Name Quantity In Out Total Date Vendor

2) The data starts on Row 7

3) So it looks like this (this data can go on for 30 rows):
Name Quantity In Out Total Date Vendor
Bandsaws 10 7 2 $700 3/20/2005 NBS
Pumice 20 1 3 $900 1/01/2005 OXS

4) The vendor IDs are located in a different worksheet. So if it would be
possible to reference it when going to word. As shown below in step 5:

5) What I want to try to get it to look like in Word:

Name: Bandsaws
Quantity: 10 units, In: 7, Out: 2, Total: $700, Date: 03/20/2005, Vendor:
National Bandsaw Company

Name: Pumice
Quantity: 20 units, In: 1, Out: 3, Total: $900, Date: 01/01/2005, Vendor:
Oxford Building Supplies

Can any of this be possible in Excel?? Thanks!!