I am converting databases at work from Access 97 to Access 2002.

One function involves

DoCmd.TransferText acExportMerge, , "sysMailMergeExports", MergeData, True

This works fine with Access 97, but with Access 2002 (XP) I get an error:

the object Letters#txt cannot be found ...

this is the value of the MergeData variable, and should read:


The program seems to get there - it actually deletes the old letters.txt file, but then hangs up with the above message.

Any help/advice would really be appreciated.