Word Merge Database Field

[vlree]

Win2000/MSAccess2000/WinXPPro
I ran across this article on the MSNDeveloper site, which near the end describes how to use a {Database \d} field in Word. I have copied the code exactly (I hope), changing only the path and attempted to link to the Northwind db but I am getting Error! Cannot open data source.

{DATABASE \d
"C:\\ VictoriasStuff\\DBTestWord\\Northwind.mdb" \c
"DSN=MS Access Databases;DBQ=C:\\ VictoriasStuff\\DBTestWord\\Northwind.mdb;DRIVERId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeOut=5;" \s "SELECT 'OrderID','CustomerID' FROM 'ORDERS' WHERE (('CustomerID' = 'ALFKI'))" \h}

MSN Article

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba00/html/MailMergePartI.asp

 

[mscallisto]

have you setup an ODBC connection

 

[vlree]

Yes I believe so, but if you would like to be more specific, I will check your suggestions.

 

[mscallisto]

From your control panel:
> administrative tools icon
> Data sources (odbc) icon

On the System DSN tab
If your data set name is not there then yoy need to create a new one

Add > Driver (SQL Server or some other)
Click finish and follow the instructions.