I have recently created a mail merge function in my fmp database. It works fine, but I need to keep a record of the sent mail. Is there any way I can create a new record in another fmp file for storing these letters.

I don't know of a way to save the letter layout as a document for each addressee, but I have a scripted method for creating a record in a log. In this you would automatically enter a text eg "sent invite to Spring seminar".The script loops through the found set and creates a record in the log for each master record. You would then be able to find the appropriate records for (say)doing a follow-up.

Would this help? If so I will post the full routine.

Thanks for your help, but I think what I have running now is going to be alright. Looks like they don't need to save a record, just as long as the found set can easily be found again.