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.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.