Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge with SQL 2000 using Query instead of just a table.
Using Word 2003 and SQL 2000
Anyone know if it's possible to merge with SQL 2000 using queries versus just one table? Currently, I can only merge with one table in SQL and I would like to merge with multiple tables using a Query. Thanks! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge with SQL 2000 using Query instead of just a table.
Do you mean Microsoft SQL Server 2000?
You can either a. create a View in SQL Server and use that as the data source or b. use Word VBA and set ActiveDocument.MailMerge.DataSource.QueryString to be the Transact-SQL query you want, as long as Word is already connected to the necessary database and the connection string will still work for the new query c. use Word VBA and its OpenDataSource method to issue a Transact-SQL query, e.g. if you are connecting from Word 2002 or later using OLE DB, you will probably be connnecting via a .odc file, in which case you can do something like: ActiveDocument.MailMerge.OpenDataSource _ Name:="the pathname of your .odc", _ Connection:="", _ SQLStatement:="your SQL query" d. If you have MS Access, create a database and link to the tables you need to query, then create a query in Access and use that as the data source. NB, there may well be performance consequences if you do things that way. Peter Jamieson "Phillip Vong" phillip_vong*at*yahoo*dot*com wrote in message ... Using Word 2003 and SQL 2000 Anyone know if it's possible to merge with SQL 2000 using queries versus just one table? Currently, I can only merge with one table in SQL and I would like to merge with multiple tables using a Query. Thanks! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge with SQL 2000 using Query instead of just a table.
That's perfect! Thanks! I'll use Views.
Phil "Peter Jamieson" wrote in message ... Do you mean Microsoft SQL Server 2000? You can either a. create a View in SQL Server and use that as the data source or b. use Word VBA and set ActiveDocument.MailMerge.DataSource.QueryString to be the Transact-SQL query you want, as long as Word is already connected to the necessary database and the connection string will still work for the new query c. use Word VBA and its OpenDataSource method to issue a Transact-SQL query, e.g. if you are connecting from Word 2002 or later using OLE DB, you will probably be connnecting via a .odc file, in which case you can do something like: ActiveDocument.MailMerge.OpenDataSource _ Name:="the pathname of your .odc", _ Connection:="", _ SQLStatement:="your SQL query" d. If you have MS Access, create a database and link to the tables you need to query, then create a query in Access and use that as the data source. NB, there may well be performance consequences if you do things that way. Peter Jamieson "Phillip Vong" phillip_vong*at*yahoo*dot*com wrote in message ... Using Word 2003 and SQL 2000 Anyone know if it's possible to merge with SQL 2000 using queries versus just one table? Currently, I can only merge with one table in SQL and I would like to merge with multiple tables using a Query. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2000 Query and Autotext | Microsoft Word Help | |||
Office 2000 Query and Autotext | Microsoft Word Help | |||
mail merge from word to a query in Access both 2003worked in 2000 | Mailmerge | |||
Office 2000-SP3 - Mail Merge- Query- Sort Records tab grayed out | Mailmerge | |||
Access 2000 mail merge from a conditional query | Mailmerge |