Hi


1.Is there a way to stop the SQL popup box at all on mail merge with VBA?
You receive the "Opening this will run the following SQL command" message when you open a Word mail merge main document that is linked to a data source


I've tried creating this code below with the hope I can do that, but it doesn't work Is something fundamentally wrong with the code below? I think it comes up with a type mismatch error on the red part.

Please Login or Register  to view this content.

2.
I've created the following:
Please Login or Register  to view this content.
But
1)Requires word to already be open with no document loaded

or

2)Opens word properly and opens the document but doesn't run the mailmerge on opening the document.