Hi,

I have a user whom we need to change the default location
for a mail merge document.  Basically, she creates a
floppy with all of the client info, which includes a word
document and excel spreadsheet that she merges together.  
In Office 2000, she would open both the word and excel
docs, do the merge, and it would look at the two open
docs and merge them together with no problem.
I upgraded her to Office 2003 and a new PC, and it
appears the mail merge is ignoring the open excel
spreadsheet and point to a default location ("my
documents") looking for this excel sheet, and therefore
pulls the wrong data into the merge.  I want it to look
at the floppy by default and use that file.  When I go
through the wizard and point it to the proper location,
it switches back to the "my documents" folder at the next
merge. Is there a way to do this?

Thanks,

Mike