Hi


The back story:


It's all about streamlining things. I've got 18 docs in separate folders, and my client will send over data to merge some or all of the docs every week. I've tried merging the 18 docs into one to make things easier, but there are some complications with this, so I'm using them separately.



I've already got some code set up to copy the new xlsx data files to replace the old files each time, and as the names will be the same, the merge (to a pdf file) works nicely when I call each doc from an Access function.


So far so good - the snag comes when the client wants the docs back to edit. They've started doing this every month or so lately. They previously used Indesign files but now want to switch to word docs.


I'm anticipating they will change the merge file to a different location as part of their editing process so they can see how the data merges, so when they send them back to me I will get the error I mentioned when the doc can't find the data file they set up as merge source.


If I can't find a solution to the error messages, I'll just have to open all the docs one at a time and reset the merge source manually, I just thought it would be nice to find some way to automate this and save a lot of clicking!