I have been using Albert Kallal mail merge code for a while without any problem. However, I have recently found a problem that I hope you expert can help solve.
When you try to fun the code to conduct a mail merge while a word document that was not opened by the code in access is already opened you get message saying:
This document will run the following SQL command:
Select * from C:\docume~1\..............
Data from your database will be placed in the document. Do you want to continue.
Clicking yes proceeds with the mail merge. Is there a way to make the code proceed without the message even when there is another open word document.
Albert Kallal db is in the attached zip folder