Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Words 2003 - Editing the SQL Query In A Merge Document
When I open up a Word (2003) Merge Document and see the following SQL
command: SELECT * FROM ''7DayLetter', ORDER BY 'Last Name' Is there a way I can edit this SQL statement? I see that Step 3 of the Mail Merge Wizard has an Advanced function in the dropdown with a frontend that would generate the above SQL but I would still be interested in editing the SQL directly in some situations. Thanks, Sheldon Potolsky |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Words 2003 - Editing the SQL Query In A Merge Document
The SQL statement you see is automatically generated by Word and it's not
something that can be directly modified. As you noted, the Advanced functions will modify the SQL statement but that's controlled by Word. If you want to use your own SQL statement then you would need to create it in a database program (or other program that support SQL) and use it as your data source. Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Sheldon" wrote in message oups.com... When I open up a Word (2003) Merge Document and see the following SQL command: SELECT * FROM ''7DayLetter', ORDER BY 'Last Name' Is there a way I can edit this SQL statement? I see that Step 3 of the Mail Merge Wizard has an Advanced function in the dropdown with a frontend that would generate the above SQL but I would still be interested in editing the SQL directly in some situations. Thanks, Sheldon Potolsky |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge - how can I use MS-Query in Word 2003? | Microsoft Word Help | |||
Word 2003 Merge won't show data in Access Query? | Mailmerge | |||
Mail merge to a query in Access 2003 | Mailmerge | |||
how do I associate a query to SQL code in a Word 2003 mail merge | Mailmerge | |||
Copy a Mail Merge Query to a new document | Mailmerge |