Re: Can I use my data source from SQL

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 08/27/04 

Date: Fri, 27 Aug 2004 11:20:59 +0100

Which version of Word?

Which "SQL" database ? SQL Server? Oracle? MySQL? Something else?

For a direct connection, in Word 97 and 2000 you have to set up the
connection using ODBC and MS Query, or using the VBA OpenDatasource method.
and you need an ODBC driver for your database and ODBC DSN for your data
source. When you get to the Open Data Source dialog box, you should see an
MS Query button. Click that, and proceed from there. If MS Query has not
been installed you will need to install it.

In Word 2002 and later the ODBC option is still available, but to get to MS
Query you have to use the Tools menu in the top right corner of the Select
Data Source dialog box. But in these versions you may also be able to
connect using OLEDB if you have a suitable provider - typically, you will
need to use either a .udl file, or a .odc file that you /may/ be able to
create using the New data source button (I forget the exact text on the
button) in Select Data Source.

Another approach if you have Access is to use Access to link to your SQL
database (it will need an ODBC driver I think) and use that Access database
table as your data source. 

-- 
Peter Jamieson
"Pooja" <Pooja@discussions.microsoft.com> wrote in message
news:952DF1D0-96A2-4FCC-892A-98D7FFDB5370@microsoft.com...
> HI,
>
>  I am new to using mail merger. I am trying to create letter form with
>
> Name, and Address field coming from SQL table.
>
> Can this be done?