Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Merge It . . .' Normal behavior? (2003)

    I have a query that I'm using as the basis for a Mail Merge and/or Labels. When I run the Query and then select 'Merge It with Microsoft Office Word', the Wizard pops up and starts me though the process of linking, merging, etc. However, the Merge is only allowing me to select a Table. I have to click Options and select Views to get the Query I'm in, but then as the Wizard continues to walk me through the Merge, it asks where the Data Source is?

    I'm taking it that it's impossible to create a Merge from a Query (at least using this method).

    Thanks in advance for your reply.

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Merge It . . .' Normal behavior? (2003)

    Have you not considered to try it the other way around. Open word and choose Tools | Mail Merge. The select the labels or form letter and follow the process to link to the query in the appropriate database.
    Regards,
    Rudi

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Merge It . . .' Normal behavior? (2003)

    It doesn't work that way either. Even if it did, the problem would be that it's a Parameter Query, so the user wouldn't be able to enter their criteria. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

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

    Re: 'Merge It . . .' Normal behavior? (2003)

    The best choice in general if you want to use a parameter query as your data source is to specify the connection method as DDE - neither ODBC connections or OLE DB connections support parameter queries. There is also a further issue with secured databases and DDE where Word will try to start another copy of Access to complete the merge, especiallly if the name of your Access application doesn't begin with "Microsoft Access..." - to solve these kind of problems we often resort to Automation to run the merge, and save a query with the specified user constraints so we can use ODBC. You might find our Word Merge Tutorial useful in exploring some of the nuances of mergeing.
    Wendell

  5. #5
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Merge It . . .' Normal behavior? (2003)

    Fair enough. So, in other words, "yes", this is normal behavior for 'Merge It . . .'

    OK, is it just me, or is it stupid to have this option enabled on Access' toolbar. Certainly an oversight on MS's behalf. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Thank you for your post and for clearing that up.

    Much appreciated (and thanks for the links).

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Merge It . . .' Normal behavior? (2003)

    It will work just fine if you aren't using a parameter query, which is why it is there on the toolbar.
    Charlotte

  7. #7
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Merge It . . .' Normal behavior? (2003)

    Fair enough. It would be nice, I guess, if it were disabled when Access detected a Parameter Query. But maybe that's too much to ask? <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 'Merge It . . .' Normal behavior? (2003)

    Access reports don't know it's a parameter query, they just know they have a recordsource. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

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