MS Query Works in Excel but not in Word Mail Merge

HOLDERS37 · 02-28-2008, 06:28 PM

I have been unable to figure this one out. Operating System is XP Service Pack 2 using Office 2003 Service Pack 3 and Sql Server 2000. I made a dqy file with Microsoft Query. It is very simple query with address information and a numeric key field. When I pull the data in with Excel all the columns show fine. However when I use the same dqy file as data source for a Mail Merge in Word, all the nvarchar fields (address name, address 1, etc) are blank. The only field that shows values is the numeric key field (integer). I can use a 'View' from sql server with a Sql Server connection in Word but I want regular office people to be able to do their own thing with Microsoft Query. Any one have any ideas on what is going on?

Any ideas would be appreciated. Thanks.

wildr · 03-31-2008, 05:45 PM

I ran into this and the solution was to do a cast on the selected fields from nvarchar to char http://msdn2.microsoft.com/en-us/library/ms187928.aspx

There may be other types you can cast it to but I only tried char.

02-28-2008, 06:28 PM	#1 (permalink)
HOLDERS37 Registered User Join Date: Feb 2008 Posts: 1 OS: XP	MS Query Works in Excel but not in Word Mail Merge I have been unable to figure this one out. Operating System is XP Service Pack 2 using Office 2003 Service Pack 3 and Sql Server 2000. I made a dqy file with Microsoft Query. It is very simple query with address information and a numeric key field. When I pull the data in with Excel all the columns show fine. However when I use the same dqy file as data source for a Mail Merge in Word, all the nvarchar fields (address name, address 1, etc) are blank. The only field that shows values is the numeric key field (integer). I can use a 'View' from sql server with a Sql Server connection in Word but I want regular office people to be able to do their own thing with Microsoft Query. Any one have any ideas on what is going on? Any ideas would be appreciated. Thanks.

03-31-2008, 05:45 PM	#2 (permalink)
wildr Registered User Join Date: Mar 2008 Posts: 1 OS: XP Pro sp 2	Re: MS Query Works in Excel but not in Word Mail Merge I ran into this and the solution was to do a cast on the selected fields from nvarchar to char http://msdn2.microsoft.com/en-us/library/ms187928.aspx There may be other types you can cast it to but I only tried char.