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.