I am using the Merge to New document button for a mail merge document and saving the letter with a name such as ABC.doc.

I need to save legal documents based on templates that can be opened at a later time for reference. The information in my Access table data source for my mail merge template changes. So, if I have saved merged information one day, it will be different the next time I use the template.

When I open my saved letters (merged documents), I am prompted to open the SQL source. I thought merging to a new document would simply save the document with the data in it and not prompt me for the data source when I open that saved document?

Do you know how I can stop this prompt? If I answer the prompt for the SQL source with Yes or No, it does open up my saved document with the data that I expect so it is not truly linking back to the data source because if it did, there would be new information in the saved letter each time.

Thank you.
Brandi