mail merge from excel to word
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
Re: mail merge from excel to word
Easiest way would be to dynamcially build a table in word to contain the data from Excel.
Here's an example of a dynamic table build. It shoul be fairly easy to modify this such that the input is an Excel range rather than a string array.
http://www.vbforums.com/showthread.p...60&postcount=8