Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Merge query into Word mail merge file does not work

Discussion in 'Information Technology' started by Ricky Gibson, Nov 11, 2005.

  1. Ricky Gibson

    Ricky Gibson
    Expand Collapse
    Guest

    I use access 2002 and have a database file with several tables.
    I have made a selection query where I want to extract certain addresses.
    In the criteria-line, in the column of for instance the field City, I have
    put for instance "London".
    When I go to Tools, Ofice Links , Merge It With Microsoft Word, I can select
    the merge-fields from the query and everything works well.

    However I also have a query with a parameter. In the criteria-line, in the
    column of the field City, I ask for the name: [City:]
    The query works fine and makes the correct selection.
    However when I try to merge this query with Word, I get the message that
    Word is unable to open de file.

    Does anybody have a clue what I do wrong?

    Rick
     
  2. Loading...


  3. [MVP] S.Clark

    [MVP] S.Clark
    Expand Collapse
    Guest

    The "parameter query" is a very specific piece of Access functionality.
    These types of Access-isms typically only work inside of Access.

    --
    Steve Clark, Access MVP
    http://www.fmsinc.com/consulting
    *FREE* Access Tips: http://www.fmsinc.com/free/tips.html

    "Ricky Gibson" <rickie@apd.nl> wrote in message
    news:6b086$4373671a$d48e0349$5890@news.chello.nl...
    >I use access 2002 and have a database file with several tables.
    > I have made a selection query where I want to extract certain addresses.
    > In the criteria-line, in the column of for instance the field City, I have
    > put for instance "London".
    > When I go to Tools, Ofice Links , Merge It With Microsoft Word, I can
    > select the merge-fields from the query and everything works well.
    >
    > However I also have a query with a parameter. In the criteria-line, in the
    > column of the field City, I ask for the name: [City:]
    > The query works fine and makes the correct selection.
    > However when I try to merge this query with Word, I get the message that
    > Word is unable to open de file.
    >
    > Does anybody have a clue what I do wrong?
    >
    > Rick
    >
    >
    >
     
  4. VAP

    VAP
    Expand Collapse
    Guest

    We have several Word merge files with access parameter queries attached and
    they work just fine.

    "[MVP] S.Clark" wrote:

    > The "parameter query" is a very specific piece of Access functionality.
    > These types of Access-isms typically only work inside of Access.
    >
    > --
    > Steve Clark, Access MVP
    > http://www.fmsinc.com/consulting
    > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
    >
    > "Ricky Gibson" <rickie@apd.nl> wrote in message
    > news:6b086$4373671a$d48e0349$5890@news.chello.nl...
    > >I use access 2002 and have a database file with several tables.
    > > I have made a selection query where I want to extract certain addresses.
    > > In the criteria-line, in the column of for instance the field City, I have
    > > put for instance "London".
    > > When I go to Tools, Ofice Links , Merge It With Microsoft Word, I can
    > > select the merge-fields from the query and everything works well.
    > >
    > > However I also have a query with a parameter. In the criteria-line, in the
    > > column of the field City, I ask for the name: [City:]
    > > The query works fine and makes the correct selection.
    > > However when I try to merge this query with Word, I get the message that
    > > Word is unable to open de file.
    > >
    > > Does anybody have a clue what I do wrong?
    > >
    > > Rick
    > >
    > >
    > >

    >
    >
    >
     
  5. Ricky Gibson

    Ricky Gibson
    Expand Collapse
    Guest

    Steve,
    I have found the following:
    My application was written in ACCESS 2000 in 1998.
    Due to a harddisk crash we are now using the application in ACCESS 2002,
    with the problem as described.
    However now I'm using the application with ACCESS 2000 and it works as
    before, no problem whatsoever.
    Could it be something with the version?

    Rick


    "[MVP] S.Clark" <steve.clark_NOSPAM@FMSInc.com> wrote in message
    news:eeZqQKi5FHA.2524@TK2MSFTNGP10.phx.gbl...
    > The "parameter query" is a very specific piece of Access functionality.
    > These types of Access-isms typically only work inside of Access.
    >
    > --
    > Steve Clark, Access MVP
    > http://www.fmsinc.com/consulting
    > *FREE* Access Tips: http://www.fmsinc.com/free/tips.html
    >
    > "Ricky Gibson" <rickie@apd.nl> wrote in message
    > news:6b086$4373671a$d48e0349$5890@news.chello.nl...
    >>I use access 2002 and have a database file with several tables.
    >> I have made a selection query where I want to extract certain addresses.
    >> In the criteria-line, in the column of for instance the field City, I
    >> have put for instance "London".
    >> When I go to Tools, Ofice Links , Merge It With Microsoft Word, I can
    >> select the merge-fields from the query and everything works well.
    >>
    >> However I also have a query with a parameter. In the criteria-line, in
    >> the column of the field City, I ask for the name: [City:]
    >> The query works fine and makes the correct selection.
    >> However when I try to merge this query with Word, I get the message that
    >> Word is unable to open de file.
    >>
    >> Does anybody have a clue what I do wrong?
    >>
    >> Rick
    >>
    >>
    >>

    >
    >
     

Share This Page