Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007

    Unanswered: Mailmerge form Access - Letter open twice

    Hello there

    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


  2. #2
    Join Date
    Feb 2004
    Chicago, IL
    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?

  3. #3
    Join Date
    May 2007
    Hi DCKunkle

    Thanks for your reply.

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts