Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Mail Merge Problem (Office XP Pro)

    Forgive me if this question has been posted before. I did a quick search and could not find anything. How do you get Word to allow you to use an Access database query as a data source? The only choice it gives me is selecting a table. In Office 2000, I had the choice of a table or query. Am I overlooking something simple? Please help! Thank you.

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

    Re: Word Mail Merge Problem (Office XP Pro)

    I recommend checking "Confirm Conversions at Open" in the General tab of Tools | Options... You will then get a choice of ways to connect to the database.

    If you select OLE DB Database Files, tables and queries will be presented in one list.
    If you select MS Access Databases via DDE, you'll get a dialog with two tab pages: Tables and Queries.
    If you select MS Access Database via ODBC (or another ODBC data source), you'll only see tables by default, but you can click Options... and check Views. This will add queries to the list.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Evansville, Indiana, USA
    Posts
    41
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Mail Merge Problem (Office XP Pro)

    Hans,

    Thank you for your super response time. As usual, you had the answer. You're great!!

    Trena

Posting Permissions

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