Completed

Excel VBA -Merge excel sheet into Word table

This project was successfully completed by deepbluetech for £70 GBP in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
£20 - £250 GBP
Completed In
3 days
Total Bids
13
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
[url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online