Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

    Am I missing something? <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> The new mail merge wizard in Word XP doesn't seem to be able to connect with an Access query--only Access tables. It does allows me to choose a query only after choosing a table. No table is appropriate, but when I choose one at random to get to the option of choosing a query, I get an error when I choose the query I need. Is this correct, or am I missing something.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

    It is in there - what type of data source are you using in step 3?

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

    Re: Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

    Are you by chance running Windows ME on your PC? We've seen some weird things with mail merges using Access, but they seem OK if you are running Windows 2000 or Windows XP.
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Feb 2010
    Location
    Denver, CO
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

    Sorry abouy the time lag. Too many projects going on a once.

    In step 3, I selected "using an existing list" and clicked on browse. It is an Access database that I connect to. Check the attached gif. Only tables are listed in the resulting dialog box. Yes, there are queries defined in that database. Any suggestions?
    Attached Images Attached Images

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

    Try the following:
    In Word, select Tools/Options...
    Activate the General tab.
    Tick the Confirm conversions at Open check box.
    Click OK.
    Now, go to step 3 of the Mail Merge task panel again, and browse to your database.
    When you click Open, you will be presented with a list of choices; select MS Access Databases via DDE.
    You should get a different dialog for selecting a data source, with separate tabs for tables and queries.

Posting Permissions

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