Word mail merge cant find source document

[jeffward]

I have a number of mail merge documents on a common network directory that use .txt files created on the users c: as the data source.

Unfortunatally I keep getting intermitent errors where Word cant find the data file and the user has to point it manually to the correct file.

 

[xlhelp]

Hi, Jeff!

A few things to try:

Check to see if the Option to Hide File Extension of Known Types is On under Tools, Folder Options in Windwos Explorer. If it is on, turn it off.

Do you know if you are using the Select Mehtod option to merge your data? That may be one of the things you need to do.

Also, is it possible that the data source may still be open from another mail-merge before?

If you are merging the data using ODBC driver, is it possible the text delimiter is not being recognized? These would be tabs, comma, pipe, and tilde.

Depending on one of the situations above being true, we could look further into solving this.

Hope some of this helps.

Indu