Excel VBA -Merge excel sheet into Word table




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,


[url removed, login to view]

Skills: Excel, Visual Basic, Word

See more: word table excel vba, excel vba merge tables, vba excel merge, vba code excel data word table, vba word merge excel sheet, excel data word table vba, word excel merge, merge worksheet data word document vba, excel merge table, excel vba sheet table name, vba merge table, merge excel table word, merge worksheet excel vba, merge excel sheet, merge excel word vba, word merge excel, merge excel table word table, vba code merge excel word, what are the application of data structure, visual basic directory info, table data structure, data structure in array, data structure array, array template, array in data structure using c

Project ID: #4777868

Awarded to:


I can take on the job. Please confirm.

£70 GBP in 3 days
(90 Reviews)

12 freelancers are bidding on average £125 for this job


Looking forward to working with you...

£105 GBP in 3 days
(71 Reviews)

Consider it done. Check your PM for my bid details.

£210 GBP in 1 day
(78 Reviews)

I have past experience of similar work.....Working sample attached in message box.

£84 GBP in 1 day
(104 Reviews)

I will give u an application which allow you to select excel file and you will see the results in report. Report can be exported to number of formats, like excel, csv,word etc See in your PMB the reporting link for More

£75 GBP in 2 days
(20 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

£78 GBP in 3 days
(18 Reviews)

Hi Griffin I am pretty expert in VBA and shall be able to get it done witin 2 days Regards

£178 GBP in 2 days
(4 Reviews)

Hello, excel wise is here. check p.m.

£115 GBP in 3 days
(9 Reviews)

Please read PM message

£88 GBP in 3 days
(7 Reviews)

I can do this for you ! Please give me chance to work with you once time, i will not make you disappointed.

£55 GBP in 2 days
(1 Review)

Expertise with Excel and VBA Worked on several projects and developed a decision support system for a clothes manufacturing company using VBA and Macros

£150 GBP in 3 days
(0 Reviews)

I have 3 years of experience in Software testing and I have a good knowledge about excel macros. I have written Vba scripts to process XML files, to handle DB manipulations and add-in's to connect to synchronize with Q More

£150 GBP in 3 days
(0 Reviews)

Hi Ray, I would like to suugest an alternative. Please read my PM

£255 GBP in 4 days
(0 Reviews)