Mail Merge - Undesirable Database Open יריב החביב 12/18/2008 7:41:01 AM Hello, I merge word document to access table. When i open the word doc, the access databse open. I dont need the data base, just the word doc (with the data of course). Is it possible and How ? thank's -- -- תודה רבה

Re: Mail Merge - Undesirable Database Open "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 12/18/2008 2:03:13 PM What you have opened is the mail merge main document, which won't work unless linked to the data source. It sounds as if you have not completed the merge to a new document. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... [Quoted Text] > Hello, > > I merge word document to access table. > > When i open the word doc, the access databse open. > > I dont need the data base, just the word doc (with the data of course). > > Is it possible and How ? > > > thank's > -- > > -- > ???? ???

Re: Mail Merge - Undesirable Database Open יריב החביב 12/18/2008 2:55:05 PM thank you, Yes,i have not completed the merge to a new document, because i want the word doc will update when i open it with updated data in the access database, and still i don't want that the database will open. (in the begining of my using that method, it did not open and suddenly somthing happened, and it started to open) thank's again -- תודה רבה "Suzanne S. Barnhill" wrote: [Quoted Text] > What you have opened is the mail merge main document, which won't work > unless linked to the data source. It sounds as if you have not completed the > merge to a new document. > > -- > Suzanne S. Barnhill > Microsoft MVP (Word) > Words into Type > Fairhope, Alabama USA > http://word.mvps.org > > "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message > news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... > > Hello, > > > > I merge word document to access table. > > > > When i open the word doc, the access databse open. > > > > I dont need the data base, just the word doc (with the data of course). > > > > Is it possible and How ? > > > > > > thank's > > -- > > > > -- > > ???? ??? > > >

Re: Mail Merge - Undesirable Database Open "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/18/2008 5:05:07 PM If your Word mail merge main document connects to the database using DDE, when Word opens the document, it will also open Access (if necessary). Access will then open the database (if necessary). To avoid opening /Access/, you have to connect using ODBC (most versions of Word) or OLE DB (Word 2002 and later). In that case, Word still opens the database using Jet (or ACE, in Word 2007), but it does not need to open Access and you do not see any extra windows. However, there are reasons why your Word document may need to connect via DDE, including: a. it connects to a parameter query and the user needs to enter a parameter b. it connects to a query that uses old-style "wildcard characters" * and ? rather than the ANSI wildcards % and _ c. it connects to a query that uses a user defined Access VBA function, or some other functions that do not work with ODBC/OLE DB ....and so on.You may also find that DDE has been used because of text truncation problems etc. However, if you do not need DDE (and I think you can only really tell by experimenting), to change the connection method, check Word->Tools->Options->general-->Confirm conversions at open (Word 2003 and earlier) or click the Office button, then check Word Options->Advanced->General->Confirm File format conversion on open. Then go through the connection proces again. -- Peter Jamieson http://tips.pjmsn.me.uk "יריב החביב" <yarivr[ at ]tasmc.health.gov.il> wrote in message news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... [Quoted Text] > Hello, > > I merge word document to access table. > > When i open the word doc, the access databse open. > > I dont need the data base, just the word doc (with the data of course). > > Is it possible and How ? > > > thank's > -- > > -- > תודה רבה

Re: Mail Merge - Undesirable Database Open "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> 12/18/2008 5:25:10 PM Also, if this data is being added to a single document (which the failure to complete the "merge" suggests), then perhaps some other linking method (INCLUDETEXT or the like) would be more appropriate than a mail merge. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message news:%23I7wILTYJHA.2280[ at ]TK2MSFTNGP06.phx.gbl... [Quoted Text] > If your Word mail merge main document connects to the database using DDE, > when Word opens the document, it will also open Access (if necessary). > Access will then open the database (if necessary). > > To avoid opening /Access/, you have to connect using ODBC (most versions > of Word) or OLE DB (Word 2002 and later). In that case, Word still opens > the database using Jet (or ACE, in Word 2007), but it does not need to > open Access and you do not see any extra windows. > > However, there are reasons why your Word document may need to connect via > DDE, including: > a. it connects to a parameter query and the user needs to enter a > parameter > b. it connects to a query that uses old-style "wildcard characters" * and > ? rather than the ANSI wildcards % and _ > c. it connects to a query that uses a user defined Access VBA function, or > some other functions that do not work with ODBC/OLE DB > > ...and so on.You may also find that DDE has been used because of text > truncation problems etc. > > However, if you do not need DDE (and I think you can only really tell by > experimenting), to change the connection method, check > Word->Tools->Options->general-->Confirm conversions at open (Word 2003 and > earlier) or click the Office button, then check Word > Options->Advanced->General->Confirm File format conversion on open. Then > go through the connection proces again. > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message > news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... >> Hello, >> >> I merge word document to access table. >> >> When i open the word doc, the access databse open. >> >> I dont need the data base, just the word doc (with the data of >> course). >> >> Is it possible and How ? >> >> >> thank's >> -- >> >> -- >> ???? ??? > >

Re: Mail Merge - Undesirable Database Open "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 12/18/2008 5:45:48 PM Good point - The only other way you'll get stuff directly from Access without actually having Access open is via a DATABASE field via ODBC/OLE DB, unless the data actually comes from linked tables in Access and could be retrieved without Access involvement. -- Peter Jamieson http://tips.pjmsn.me.uk "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> wrote in message news:uhoYSZTYJHA.5020[ at ]TK2MSFTNGP03.phx.gbl... [Quoted Text] > Also, if this data is being added to a single document (which the failure > to complete the "merge" suggests), then perhaps some other linking method > (INCLUDETEXT or the like) would be more appropriate than a mail merge. > > -- > Suzanne S. Barnhill > Microsoft MVP (Word) > Words into Type > Fairhope, Alabama USA > http://word.mvps.org > > "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message > news:%23I7wILTYJHA.2280[ at ]TK2MSFTNGP06.phx.gbl... >> If your Word mail merge main document connects to the database using DDE, >> when Word opens the document, it will also open Access (if necessary). >> Access will then open the database (if necessary). >> >> To avoid opening /Access/, you have to connect using ODBC (most versions >> of Word) or OLE DB (Word 2002 and later). In that case, Word still opens >> the database using Jet (or ACE, in Word 2007), but it does not need to >> open Access and you do not see any extra windows. >> >> However, there are reasons why your Word document may need to connect via >> DDE, including: >> a. it connects to a parameter query and the user needs to enter a >> parameter >> b. it connects to a query that uses old-style "wildcard characters" * and >> ? rather than the ANSI wildcards % and _ >> c. it connects to a query that uses a user defined Access VBA function, >> or some other functions that do not work with ODBC/OLE DB >> >> ...and so on.You may also find that DDE has been used because of text >> truncation problems etc. >> >> However, if you do not need DDE (and I think you can only really tell by >> experimenting), to change the connection method, check >> Word->Tools->Options->general-->Confirm conversions at open (Word 2003 >> and earlier) or click the Office button, then check Word >> Options->Advanced->General->Confirm File format conversion on open. Then >> go through the connection proces again. >> >> -- >> Peter Jamieson >> http://tips.pjmsn.me.uk >> >> "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message >> news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... >>> Hello, >>> >>> I merge word document to access table. >>> >>> When i open the word doc, the access databse open. >>> >>> I dont need the data base, just the word doc (with the data of >>> course). >>> >>> Is it possible and How ? >>> >>> >>> thank's >>> -- >>> >>> -- >>> ???? ??? >> >> > >

Re: Mail Merge - Undesirable Database Open יריב החביב 12/22/2008 7:28:01 AM Thank You Very Very Much !!!!!!!!!!!! -- תודה רבה "Peter Jamieson" wrote: [Quoted Text] > Good point - The only other way you'll get stuff directly from Access > without actually having Access open is via a DATABASE field via ODBC/OLE DB, > unless the data actually comes from linked tables in Access and could be > retrieved without Access involvement. > > -- > Peter Jamieson > http://tips.pjmsn.me.uk > > "Suzanne S. Barnhill" <sbarnhill[ at ]mvps.org> wrote in message > news:uhoYSZTYJHA.5020[ at ]TK2MSFTNGP03.phx.gbl... > > Also, if this data is being added to a single document (which the failure > > to complete the "merge" suggests), then perhaps some other linking method > > (INCLUDETEXT or the like) would be more appropriate than a mail merge. > > > > -- > > Suzanne S. Barnhill > > Microsoft MVP (Word) > > Words into Type > > Fairhope, Alabama USA > > http://word.mvps.org > > > > "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message > > news:%23I7wILTYJHA.2280[ at ]TK2MSFTNGP06.phx.gbl... > >> If your Word mail merge main document connects to the database using DDE, > >> when Word opens the document, it will also open Access (if necessary). > >> Access will then open the database (if necessary). > >> > >> To avoid opening /Access/, you have to connect using ODBC (most versions > >> of Word) or OLE DB (Word 2002 and later). In that case, Word still opens > >> the database using Jet (or ACE, in Word 2007), but it does not need to > >> open Access and you do not see any extra windows. > >> > >> However, there are reasons why your Word document may need to connect via > >> DDE, including: > >> a. it connects to a parameter query and the user needs to enter a > >> parameter > >> b. it connects to a query that uses old-style "wildcard characters" * and > >> ? rather than the ANSI wildcards % and _ > >> c. it connects to a query that uses a user defined Access VBA function, > >> or some other functions that do not work with ODBC/OLE DB > >> > >> ...and so on.You may also find that DDE has been used because of text > >> truncation problems etc. > >> > >> However, if you do not need DDE (and I think you can only really tell by > >> experimenting), to change the connection method, check > >> Word->Tools->Options->general-->Confirm conversions at open (Word 2003 > >> and earlier) or click the Office button, then check Word > >> Options->Advanced->General->Confirm File format conversion on open. Then > >> go through the connection proces again. > >> > >> -- > >> Peter Jamieson > >> http://tips.pjmsn.me.uk > >> > >> "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message > >> news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... > >>> Hello, > >>> > >>> I merge word document to access table. > >>> > >>> When i open the word doc, the access databse open. > >>> > >>> I dont need the data base, just the word doc (with the data of > >>> course). > >>> > >>> Is it possible and How ? > >>> > >>> > >>> thank's > >>> -- > >>> > >>> -- > >>> ???? ??? > >> > >> > > > > > >

Re: Mail Merge - Undesirable Database Open יריב החביב 12/22/2008 7:28:02 AM thank you -- תודה רבה "Suzanne S. Barnhill" wrote: [Quoted Text] > Also, if this data is being added to a single document (which the failure to > complete the "merge" suggests), then perhaps some other linking method > (INCLUDETEXT or the like) would be more appropriate than a mail merge. > > -- > Suzanne S. Barnhill > Microsoft MVP (Word) > Words into Type > Fairhope, Alabama USA > http://word.mvps.org > > "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> wrote in message > news:%23I7wILTYJHA.2280[ at ]TK2MSFTNGP06.phx.gbl... > > If your Word mail merge main document connects to the database using DDE, > > when Word opens the document, it will also open Access (if necessary). > > Access will then open the database (if necessary). > > > > To avoid opening /Access/, you have to connect using ODBC (most versions > > of Word) or OLE DB (Word 2002 and later). In that case, Word still opens > > the database using Jet (or ACE, in Word 2007), but it does not need to > > open Access and you do not see any extra windows. > > > > However, there are reasons why your Word document may need to connect via > > DDE, including: > > a. it connects to a parameter query and the user needs to enter a > > parameter > > b. it connects to a query that uses old-style "wildcard characters" * and > > ? rather than the ANSI wildcards % and _ > > c. it connects to a query that uses a user defined Access VBA function, or > > some other functions that do not work with ODBC/OLE DB > > > > ...and so on.You may also find that DDE has been used because of text > > truncation problems etc. > > > > However, if you do not need DDE (and I think you can only really tell by > > experimenting), to change the connection method, check > > Word->Tools->Options->general-->Confirm conversions at open (Word 2003 and > > earlier) or click the Office button, then check Word > > Options->Advanced->General->Confirm File format conversion on open. Then > > go through the connection proces again. > > > > -- > > Peter Jamieson > > http://tips.pjmsn.me.uk > > > > "???? ?????" <yarivr[ at ]tasmc.health.gov.il> wrote in message > > news:7B9A52AB-D657-41A5-BACA-B304EAE14F76[ at ]microsoft.com... > >> Hello, > >> > >> I merge word document to access table. > >> > >> When i open the word doc, the access databse open. > >> > >> I dont need the data base, just the word doc (with the data of > >> course). > >> > >> Is it possible and How ? > >> > >> > >> thank's > >> -- > >> > >> -- > >> ???? ??? > > > > > > >