Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail merge Word 2002 Access97 (Office 2002/ Access97)

    Hi all.

    My computer has been upgraded to Office 2002, except for Access which remains version 97. From this moment on I have a problem with Mail Merge.

    I have a (select) query in Access 97, that I "Merge with MS Word". I merge the data with an existing Word document (created in Word 97). This worked fine in Office 97. But this not seem to work anymore. The Mail Merge Wizard still starts, I choose for "Link your data with an existing Word document", I locate this specific Word document, then Word opens with the document and then (and this is what never happened in the old Office 97 environment) I get a pop-up window asking me to "Select table". In this window there are tables and some (not all) queries from my database, but the query I want is not listed. So I cannot retrieve the data I want, because the query gets data from different tables.

    I tested the database on an other computer with Office 97 still installed, and there this problem does not occur.

    Upgrading to Access 2002 is not an option for the moment, so if someone recognizes the problem and/or knows how to fix this, I would be very happy with your help.

    MTIA

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Access97)

    It sounds as if the merge is being setup using ODBC - which is actually the better method, but does not support parameter queries in Access. You would probably be better off to use DDE in your situation, which does support parameter queries. Actually you are playing with fire trying to make Word 2002 work with Access 97 as the Mail Merge feature changed dramatically in Word 2002. If you do a search of the Lounge using Word 2002 and DDE you should find several threads which tell you how to set DDE as your preferred method for doing a merge in Word 2002.
    Wendell

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Ac

    One of the better methods that has been suggested for mail merge with Office XP & Access is found in <post#=373769>post 373769</post#> by HansV.
    Cheers,

  4. #4
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Ac

    Hi Phil,

    Sorry for replying so late.

    I have used the method from Hans V. in <post#=373769>post 373769</post#> as you indicated. This works, so thank you for pointing me to that post.
    But (unfortunately there is often a but), what I really would like to do is to start from my query in the Access 97 database and do a "Merge with MS Word". And this method still fails. I have selected the setting "Confirm conversion at open" in Word 2002, but after I open the main document, I still get the pop-up window "Select table" with the query I want not listed. Is there a solution to this ?

  5. #5
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Access97)

    Hi Wendell,

    Thanks for your reply. As mentioned in my <post#=410597>post 410597</post#> to Phil, I can use the method described by Hans V.
    But I would like to learn more about the mail merge in Office XP, so I am searching through the Lounge as you suggested.

    Please have a look at my <post#=410597>post 410597</post#> to Phil, as I explained there what I would like to do. If you could give some clues, I would be very grateful.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Ac

    Hi Walter:
    If you have your query open when you choose Tools/Office Links/Merge it with MS Word, you should be able to merge directly from your open query. At least, it works that way in Office 2000. Have you tried that?

  7. #7
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Access97)

    I believe the issue has to do with the way that Access 97 kicks off a word merge - it defaults to an ODBC connection. You could correct that behavior by creating your own automation routine in VBA to execute the merge and specify that a DDE connection is to be used - although that can be problematic if you hav a secured database. You might want to look at our Word Merge Tutorial and the WAW article that it links to for some added info on the issues. This MSKB article may also be of use - 320476 - Some Access Database Queries Are Unavailable as Data Sources in the Mail Merge Wizard. Hope this helps.
    Wendell

  8. #8
    2 Star Lounger
    Join Date
    Apr 2003
    Location
    Kontich, Vlaanderen, Belgium
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mail merge Word 2002 Access97 (Office 2002/ Ac

    Hi Phil,

    I just tried your suggestion, but it is still a "no-go". The pop-up "Select table" keeps coming without listing the query I need. Obviously Word 2002 behaves differently from Word 2000.
    I'm working my way through the suggestions of Wendell now.

    Anyway, thank you for trying to help me. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

Posting Permissions

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