View Single Post
  #1   Report Post  
Dave Foote
 
Posts: n/a
Default Cannot Find Its Data Source

We are having trouble with the Mail Merge in WordXP which are on the verge of
rolling out to all of our staff.

Once a document has been created and saved with a mail merge that has been
linked to a data source the document will re-open correctly provided NO
FILTER has been placed on the data source. If the document is saved with a
filter in place when you re open the document a message of the form:

abc.doc is a mail merge main document. Word cannot find its data source,
\\aserver\datadir\abc1.xls

(Note this also happens using Access Databases as the data source so is not
an exclusive excel/word issue)

You then have the option to locate the data source or effectively remove all
the header info and so remove all the mail merge functions.

So effectively you have to relocate the data source each time you open the
mail merge document.

Any ides how to correct this?