MailMerge Issue

[Marko Mitrov]

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.

 

[Cindy M -WordMVP-]

Hi Marko,

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.

No, there is unfortunately no way to get Word to do this
for you. Mail merge writes the exact and absolute path into
the main merge document.

Best you could do would be a macro that automates
re-linking the datasource in, based on the current main
merge document's file location. How conversant are you with
macros?

Which version of Word are we dealing with?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail