Results 1 to 10 of 10
  1. #1
    jktobin
    Guest

    Word Mailmerge with access

    I am using a table in access as my data source for a word mailmerge. Once I merge the document, I save it for editing later. When I open the merged document it always opens access. Is there any way I can sever the link. It occurs in all versions.
    Thanks
    Joe

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Word Mailmerge with access

    I just ran a test with Word2000/Access2000, saved my new "catalog" closed my "main document" and re-opened my catalog. Access did not open. Yours works differently?

  3. #3
    BAM
    Guest

    Re: Word Mailmerge with access

    Hi Joe,

    If you are merging to a new document then the link to the data source should be severed since you are completing the merge.

    If you want to break the link to the data source on the Main Document, then go to Tools/Mail Merge and under the Create command you'll find "Restore to Normal Word document".
    ~~~~~~~~~~~
    Cheers!

  4. #4
    jktobin
    Guest

    Re: Word Mailmerge with access

    I must be doing something wrong. Use a template in word. Use mailmerge to link with a quary of a table in an access database. I use the default link method in the mailmerge wizard. I think it use dde not odbc. I then use a quary in the mailmerge wizard to select a single record. I merge to a new document and save that new document. The main document to I merge to is a draft of a long trust. When I open the saved result of the merge, access opens. If I open several of the saved documents that were a result of a merge, then access opens for each. When I hit 6 documents, Word has a fatal exception. This has been the norm since Word 95, but opening up multiple copies of access only started with office 2000. I appreciate your assistance and ideas. I also have a friend that is having the very same problem.
    joe

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Mailmerge with access

    I have to ask why you need to save the merged document at all. That is one reason I use mail merges all of the time as I have the data stored in one central place and the form letter saved as a template. Whenever I need to, I can create a new document based on the template, but I don't need to save the resulting document.

    The merged document has arrows in the toolbar which allow me to scroll through the different records in the database, without opening the document multiple times.

    Hopefully this may simplify what you are trying to achieve.
    <img src=/S/thinks.gif border=0 alt=thinks width=15 height=15>

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Word Mailmerge with access

    A thought: what if you change the template to Normal before saving the merge results? (Maybe it already is Normal, in which case, never mind.)

  7. #7
    jktobin
    Guest

    Re: Word Mailmerge with access

    I use this process to merge client information into a complex tax planning trust. The template has all my standard trust clauses which I edit into a rough draft. Then I merge the rough draft with the client data. The merged result is my first draft and must undergo many revisions. I may have up to 10 documents for a husband and wife so opening up access for each document is a problem even with 256 meg of ram.
    Joe

  8. #8
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    New Zealand
    Posts
    295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Mailmerge with access

    Ok now I see what you are up to. Once the merge has been performed for the client information, do you need to go back to access for more information on that document??? You could for example merge to a new document, but only merge the one record from the database and you have the customer information from the database on a clean non merge document. You can then edit the rest of that document to your hearts content without having to worry about Access. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  9. #9
    jktobin
    Guest

    Re: Word Mailmerge with access

    No I don't need to go back to access again for that document. I only merge one record at a time into a new document, but the link comes with the new document and has since word 95. I have thought about doing a select all, copy and past into a new document to see if that helps, but never have the time. This was not a big problem until word 2000 and the way it opens documents. I have had to deal with this for over 5 years but never took the time to try to fix it. I wonder if it has anyting to do with the field trying to update themselves?
    Thanks for your post,
    joe

  10. #10
    BAM
    Guest

    Re: Word Mailmerge with access

    Hi Joe,

    I suspect that there is a database field in the document for the completed merge that may be maintaining the link to Access. Is this a one to many merge?

    Press <Alt F9> to toggle the field codes to see if this is the case.

    As for the multiple instances, two things to look at:
    1) In Access under Tool/Options and on the General tab (I think) see if turning off "Windows in the taskbar" makes a difference.

    2) Did you recently add an Application Title in Tools/Startup?

    If so then that is the problem. Word is looking for a window titled Microsoft Access. When it can not find one it starts the database again. You can control this programmatically if interested. See this article by Dev Ashish, Microsoft Access MVP:
    <A target="_blank" HREF=http://www.mvps.org/access/bugs/bugs0011.htm>http://www.mvps.org/access/bugs/bugs0011.htm</A>
    ~~~~~~~~~~~~
    Cheers!

Posting Permissions

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