I have a template workbook in Excel that will hold details that relate to accounts on our credit control system. This workbook will hold data such as Invoice Date, Invoice Amount, Invoice Number, etc in columnar form.

I want to present this data on a template word document to be sent to customers giving details of all the data held on the excel workbook. This data needs to be presented in columnar form, ie

Invoice date Invoice Number Invoice Amount
29/03/06 INV001 155.00
01/04/06 INV002 150.00
02/04/06 INV003 125.00

My problem is that I don't know how to transfer this data to the word document. I am assuming that the data ranges in Excel need to be named and the transfered to bookmarks in Word.

Any help with this would be greatly appreciated as I am really stuck!!


Thanks