OK, so I’m 95% there, but I’ve hit another snag, the original document opens, the form appears, you make your filter selections, hit generate, it creates a new document with the mail merge data, then closes the original document without saving (so it can’t be messed with) there is only one document now open. Save this document and reopen it and the form reappears, how do I stop this?
I want to put an image in the document, relative to two merge fields AND the path to the document, any ideas how I’d do it? Have played with INCLUDEPICTURE but I can’t get the document path to be included, I don’t want to put the path in the original excel document as it will change but it will always be the same relative to the open document, AND just to possibly muddy things it has to be a UNC.
Get all that, I hope so 'cos I didn’t