Unanswered: Mailmerge form Access - Letter open twice
I try to get the mailmerge letter opened by a Command Button.
Its works fine but the only problem is that it opens initially the Document with another name (Letters1) and the mailmerge toolbar is not functioning. After I close it the right name apperars and I can manipulate the documents with the mailemerg toolbar.
How can I get rid of the first document that it opens initially.
The code I use is:
Dim Ws_Name As String
Dim objWord As Word.Document
Ws_Name = "Memo random"
Set objWord = GetObject(Application.CurrentProject.Path & "\" & Ws_Name & ".doc", "Word.Document")
objWord.Application.Visible = True
Is that all of your code? If so, it doesn't look like you are closing the documnet. Is MSWORD still running in the Task Manager? If it is can you terminate it, run your code and see if the problem goes away?
I get this problem even it is the first run since I switched on the computer.
This run has to produce 12 letters and the interesting thing is that I get the 12 letters produced one after another and only after I close it I can see the 12 letters thru the Mailmerge Toolbar that it should be like that in the first place.