VBA Code to Mail-Merge Last Row of Excel to a MS Word DOcument

  • Hello Friends,


    I have searched the forum for suitable answers and didnt find solution to My Problem.


    I have uploaded One Excel Macro Enabled Document and 2 Word templates. Basically, I have some textboxes where I enter data and this data is updated to last row of the excel file. Then I will choose the template I want from the combo box and click the generate report button. My problem now is I am unable to find a suitable code which can extract data from last row of excel do a mail-merge to the word template which is selected from the dropdown combo-box.

    I would appreciate some help and suggestions here.