Excel VBA -Merge excel sheet into Word table

Budget £20 - £250 GBP
Bids 13
Average Bid £124

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]

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

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

Bids on this Project

  • maverick44000 Profile Picture

    maverick44000

    Islamabad,  Pakistan

    I am a devoted freelancer and have been developing MS Outlook and Excel add-ins using .Net technology for many years. Ranging from very basic to utterly complex add-in requirements, I have maintained a 100 percent success rate so far. I am also highly versed in VBA scripting. If you are seeking MS Office product integration with a 3rd party app or need an Excel solution using customized user interface, I can assure you a quality and professional product at the end of the day. Please refer to my clients testimony about my work. Thank you and have a good day.

    C Programming, Visual Basic, .NET, and Windows Desktop

  • pkcyber Profile Picture

    pkcyber

    LAHORE,  Pakistan

    We believe that imagination is the source of all great achievements. We believe that imagination is the springboard that propels an individual, a company or a society to new heights.

    PHP, Javascript, .NET, and Graphic Design

  • olleburger Profile Picture

    olleburger

    Melbourne,  Australia

    Enterprise level web developer, Sharepoint Specialist, Sharepoint App Developer, Lightswitch developer, MS Access/SQL Developer, Office 365 Specialist and Business Analyst.

    Website Design, Excel, Photoshop, and SQL

  • sonarkaushik Profile Picture

    sonarkaushik

    kolkata,  India

    We have over 10 of years experience in PHP, MySQL, JavaScript, CMS (Jomla, WordPress, Drupal), Graphic & Web Design, Logo & Banner Design, Flash, Data Entry, Data conversion, OCR, E-book making, Proof reading, Online Research, Data Extract, office packages, Form Fillup, Market Survey, Web Design and Seo, Increasing FB Likes, Twitter Followers, Youtube Views, Bringing traffic to sites.etc. We have a great team of experienced professionals, who are very creative and outstandingly talented. Together, we are able to work on any jobs that are related to the above-mentioned categories.

    PHP, Perl, ASP, and XML

  • deepbluetech Profile Picture

    deepbluetech

    BANGALORE,  India

    I am an individual freelancer with more than 10 years of Office automation and Software programming experience. My areas of expertise include Excel Dashboards, Excel Macros, Excel Formulas and Office data Management. I have qualified in the US / UK English exams.

    Visual Basic, Graphic Design, Banner Design, and Windows Desktop

  • venkathari123 Profile Picture

    venkathari123

    Fairborn,  United States

    I am a Masters Student looking for competitive projects in SQL, Java, Excel , Visual Basic, Data Mining and Data Entry.

    Java, Data Processing, Data Entry, and Excel

  • mrbrave Profile Picture

    mrbrave

    Lahore,  Pakistan

    Expert VBA Developer VB.net Developer PHP developer

    PHP, C Programming, Java, and Javascript

  • NhatAnhIT Profile Picture

    NhatAnhIT

    Thành ph? H? Chí Minh,  Vietnam

    I have much experience in android, web services, soap, restFul webservice, JSON xml, database, SQLite,... Give me a chance and i will give you a good work :)

    PHP, Java, XML, and Visual Basic

  • pavanperi Profile Picture

    pavanperi

    Toronto,  Canada

    I have four years of experience in analysis and internal consulting for multinational clients with expertise in information services and retail industries. Skilled in preparing business plans and helping companies provide a strategic direction, provide insights on best practices in IT and ways to improve internal operations.

    .NET, Project Management, Data Entry, and Research

  • rbbahia Profile Picture

    rbbahia

    recife,  Brazil

    I Have experience with, SQL, Oracle, VBA, C# and Visual Basic.

    Visual Basic, Data Processing, Data Entry, and Link Building