How to open a Word document contains mail merge with Excel VBA

[lindsay13]

Hi all, I already have a word document with mail merge linked to the excel spreadsheet. Now I created a button in this spreadsheet and I want to be able to click and open the word document. I have tried several times, but it will only open the word document with no mail merge.

I tried all the following answers for help, but all of them will only open word document with missing mail merge. And yes I enabled reference 'MS Word 14.0 object library' and 'MS Form 2.0 object library'

https://www.mrexcel.com/forum/gener...ing-mailmerged-details-excel.html#post4675634

https://www.mrexcel.com/forum/gener...ing-mailmerged-details-excel.html#post4675634

https://stackoverflow.com/questions/1357121/executing-word-mail-merge?answertab=active#tab-top

I appreciate all your help!