Word 2007 Mail Merge using SQL query rather than whole table

I want to merge data from an address table in an SQL2000 database into a word document. I'm using Word 2007 and I can only seem to be able to load an entire table. I'd like to be able to specify the data I want using a SQL query. I had tried using MS Query via Excel and saving a .dqy file to use in Word, but have had weird results. Some data fields for nvarchar data types are blank.

I guessed that since posting the question and it works, but was wondering if there was a more elegant and flexible solution. I'd like to be able modify the query on a regular basis, and it would be nice to do this in word rather than firing up SQL Enterprise Manager to modify a View. Seems Microsoft missed a trick here with Word 2007.

0

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Shortcuts in Word
Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…

Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …