Excel VBA -Merge excel sheet into Word table

IN PROGRESS
Bids
13
Avg Bid (GBP)
£124
Project Budget (GBP)
£20 - £250

Project Description:
Hi,
I am in the process of creating an Excel VBA add-in that merges data into a Word template table (or tables).
The user selects the Word template, then the Word table name and source worksheet for each table they want to include.
I have done VBA merges before, but never into a Word table structure and after a few attempts I have come to the conclusion that I need to hire someone with more Word VBA knowledge than I have.

So far I have the following working good:
Word application object
Word document object
Word table object (number)
Word table name (from table number)

I also have an array or worksheet of source data to fill the merge fields with. The rules are:
1 row in the excel sheet = 1 row in the Word table
excel row 1 headings = Word table merge field names

What I need is for you to provide Word VBA code to make this possible any way you can (hopefully via the MailMerge method).

I have read that this is possible using the Catalog or Directory arguments of the Word MailMerge method. This is where I am lost.

This project has a deadline of about 3-4 days.

Please let me know if you need any more info?
Kind regards,
Roy
www.LondonSoftwareSolutions.com

Skills required:
Excel, Visual Basic, Word
Additional Files: Status_Report_Template_1_-_Option_3_(multiple_tables).dotx
Hire GriffinVBA
Project posted by:
GriffinVBA United Kingdom
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 105
in 3 days
£ 210
in 1 days
Hire mrbrave
£ 84
in 1 days
£ 75
in 2 days
£ 70
in 3 days
£ 78
in 3 days
Hire maverick44000
£ 178
in 2 days
£ 115
in 3 days
£ 88
in 3 days
£ 55
in 2 days