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?
[url removed, login to view]