When using MS Word Mail Merge it forgets which database to use i.e. Excel?
Unfortunately, Word sometimes forgets where your data source is, even if it wasOK the last time you opened the merge file. If it comes up with a request to find the data source when you open the file, it is because it has got its links confused for some reason! Do NOT at this point try to find the file this would indeed cause it to work for this session but it will usually still be wrong next time you open it even if you now save it!