What is best method to query SQL 2000 DB & mail merge w/ Word 2007

C

CathyW

Does anyone have an example of the best way to query a SQL 2000 DB, prompt
for criteria (such as ID or date range) and then use the data in a mail merge
with word 2007?
I have tried since Office 2003 and cannot make a parameter query work in a
mail merge in word. I get "Word was unable to open the data file". I have
read the support articles and cannot make any of the recommendations work.
I have been using Access with link tables to prompt for the data and print
reports from Access, but that is cumbersome and ugly formatting.
Using Microsoft Query and Excel works, but opening and saving the files and
then going into word to pull from the excel file is also cumbersome.
I would appreciate any assistance.
 
C

CathyW

I did find that I could use an ODC to a table or view in the database. The
first time to set new ODC, I clicked use existing list, then at the prompt
for the data source, click new source, Microsoft SQL Server, select the
Database, then use the table or view (I created a view to simplify the
process). On the confirm Data Source, OLE DB Database Files. Once the
document has been set up, you can edit recipient list from the mailings
toolbar, filter from any column that is available and then continue to merge.
To refresh the data without closing the document, while in the mail merge
recipients window, click the Data Source, then click refresh.
 
Top