I Have a problem regarding merging an MS Excel database
and MS Word files. I created a database ( MS Excel), and
using the MailMerge option from the menu Tools in Ms Word
I connected it with a number of MS Word files. So, in my
working folder there is a database connected with a lot
of MS Word files. When I copy the database together with
the MS Word files in another folder, the problem
appears : the MS Word files are still connected with the
database in the original folder. Then, I need to re-
connect all those MS Word files with the database in the
new folder all over again. Is there an option, when I
copy the database with the MS Word files in another
folder, the data source to be changed automatically. That
will save me a lot of time because I work with 15-16 MS
Word files that need to re-connect with the base each
time I copy them to another folder. That will improve my
efficiency in my work.