Mail merge data file location

**Mr_Phil** · 03-13-2017, 01:54 PM

Hi, I finally created my first mail merge successfully! yahoo :-)

Now I want to send the datafile and the word document with the mailmerge setup to a co-worker in another state. Can I edit the word document settings so that instead of specifically looking on MY desktop for the excel datafile it will just look in the same folder as the word document? My buddy is a great guy but he quit learning about computers activily right around window 3.1. So, since we run the same reports but on different offices my mail merge will work for him. But, I want to make it as close to automatic as possible.

Many thanks in advance.

**macropod** · 03-13-2017, 07:03 PM

Originally Posted by Mr_Phil

Can I edit the word document settings so that instead of specifically looking on MY desktop for the excel datafile it will just look in the same folder as the word document?

Unfortunately, no. However, if you and your co-worker use a generic location for the datasource (e.g. C:\DataSource), you could both use that folder for either the datasource alone or both it and the mailmerge main document; otherwise your co-worker would have to set up his own connection between the mailmerge main document and datasource.