I have written a networked copy of a database and I want to add VBA code to copy a query recordset to a file on the C: drive so I can use this file as a source for Word MailMerge. I cannot seem to find any code that will work.

There may be another way to solve the problem? I need to ensure that the search generated by a user will be available for that user as a mail merge source some hours later (another user may have generated other queries using the same code in the mean time). By saving the query to the c: drive the user can have confidence that his query results are not overwritten.

I am using MS Access 2002:)

Help! anyone!

Ivan

Why not export the query as an Excel or CSV file? You can implement this in code [TransferSpreadsheet() method] or call up the menu item File|Export after selecting the query.