I have a docx file that is using an output excel from a ms access (2007-2016 I believe) to do a mail merge. What I am trying to do is just open that docx file up with a button push from the access database (using vba code) which I can do, but it not opening as a merged document. It is just opening. But when I open the file up on its own it does the merge fine on its own. Is it the instance of word I am opening? Or is it read only? Can’t seem to sort it out. Would just be an elegant way to handle this if i could export the data then open the word file up.
So as I said above, I can open the document but it is not doing the merge when opening for some reason. I have tried messing with settings but no luck so far.