Microsoft Access feeding Word Mail Merge

[Nigel]

I am developing an Access (2000) application to create and save Word mail
merged documents. I have created the Word document, linked it to a txt file
created from a query within Access and the process is almost working.

The Access database outputs the txt file, opens the linked Word letter, and
saves the resulting letter. This is all coded in VBA and runs from an Access
command button.

BUT, each time Word opens in this process it asks if the link to the txt
file should be made - I don't want this message to show because of course I
want it to link! Can I suppress this message?

AND when I save the merged document (using objWord.SaveAs) it saves it as a
Mail Merge document and I want it to be saved as the finished article - ie
populated with the fields. If I use objWord.MailMerge.Destination =
wdSendToNewDocument then it gives me no control over the name of the file or
its folder path until I close it. I need to be able to save it to its final
destination as part of the Mail Merge process.

The folder paths are different for each document produced - each document is
the first of a set to be saved under a folder given the same name as the
document reference.

Thanks for any help...