how to "disconnect" database connection in Word mail merge?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lee
    #1

    how to "disconnect" database connection in Word mail merge?

    I have a Word template that is set to merge with our client database. After
    I run the merge, I merge to a new document, and then save the new document.
    When I reopen this saved document, it prompts Access to open and request
    information from the underlying query. Since I've already merged and saved
    the new document with the merged info, I don't want Word to prompt Access
    anymore. How to I "sever" the connection between Word and Access?

    Thanks,

    Lee


    Tags: None
    • Mal Reeve
      #2
      Re: how to "disconnec t" database connection in Word mail merge?

      By design Word will refresh the data source....be that a list, table, excel
      file or Access database.

      If you really don't want to do that.....
      then select "Merge to a new file"....save that new file...which will contain
      all the data, but no merge field codes.
      And don't keep the merge document that made it.

      Mal.

      "Lee" <lrouse2REMOVEM E@cox.net> wrote in message
      news:cE3dc.92$0 h6.72@lakeread0 2...[color=blue]
      > I have a Word template that is set to merge with our client database.[/color]
      After[color=blue]
      > I run the merge, I merge to a new document, and then save the new[/color]
      document.[color=blue]
      > When I reopen this saved document, it prompts Access to open and request
      > information from the underlying query. Since I've already merged and saved
      > the new document with the merged info, I don't want Word to prompt Access
      > anymore. How to I "sever" the connection between Word and Access?
      >
      > Thanks,
      >
      > Lee
      >
      >[/color]


        Comment

        • Pieter Linden
          #3
          Re: how to &quot;disconnec t&quot; database connection in Word mail merge?

          "Lee" <lrouse2REMOVEM E@cox.net> wrote in message news:<cE3dc.92$ 0h6.72@lakeread 02>...[color=blue]
          > I have a Word template that is set to merge with our client database. After
          > I run the merge, I merge to a new document, and then save the new document.
          > When I reopen this saved document, it prompts Access to open and request
          > information from the underlying query. Since I've already merged and saved
          > the new document with the merged info, I don't want Word to prompt Access
          > anymore. How to I "sever" the connection between Word and Access?
          >
          > Thanks,
          >
          > Lee[/color]

          You could use the code from Albert Kallal's website. He exports the
          selected record(s) to a CSV file and runs the merge from there - so
          there's no source document for Word to "remember".

          http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html


          HTH,
          Pieter

            Comment

            Previous template Next
            Working...