SQL data into Word

[JB]

Hi,

I've set up a Word template that I'd like to populate with data from
an SQL database for a specific record. I've tried using the mailmerge
function and that works for just one time, the database and tables
need manually relinked everytime the template is open.

Ideally my users should just open the template, automatically link to
the SQL server then the user enters the search word and filter the
record to insert into the document.

Any advice is welcomed.

Thanks
Sean

 

[Doug Robbins - Word MVP]

Hi JB,

See the article "Access a database and insert into a Word document the data
that you find there" at:

http://www.mvps.org/word/FAQs/InterDev/GetDataFromDB.htm

It may give you some clues.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP