How to create MS Word document automatically with Excel

Generating the MS word report automatically using the excel as data source.

Mail merge is used to link data from excel to word. Them a simple macro is run to get the desired record from excel.

Download the MS word document and Excel spread sheet used in this video here

Subscribe to my channel:
YouTube Channel:
My Blog:…

14 thoughts on “How to create MS Word document automatically with Excel

  1. Hai Sir…is there any possibility to populate specific values from excel and put them in specific locations in the word file automatically. Please share your mail id so that i can share my data to you to know the possibility.

  2. 1.sir is there any way to generate doc file from the details of excel data …
    like this COMPANY NAME 3 copies for 3 individual employee
    2.How to generate a single COMPANY NAME doc with details of all the individual employee present in the employee. xls instead of asking the employee name in the prompt box

  3. Excellent content boss. You should have kept the tittle something like "Dynamic linking between MS Excel and MS word". It took me 10 videos to reach to yours – the one I'm actually searching for. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *