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.

  • Here's the code

  • Well done ChatGPT !!! ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!