Mail merge error
 

Hello all,

i know this isnt exactly a excel query BUT!!

i have a excel project (using user forms as the person
isnt allowed to edit the data on the sheet)
this project uses mailmerge in word to print letters for
applicants.

all this works fine on my documents, but... when put on
the offices server, the mail merge asks the users to find
the excel file to be used!!

as these files will be moved around alot (but always kept
in the same folder!!!) is there any way of setting the
mailmerge so that it will find the excel file in the same
folder as the word doc???

does this need VB or is it a simple options menu???

Thank you,

Robert Couchman
)