Is this possible.

[Anthony]

Can I setup a Word document to do this:

1.) When opened prompt user to supply a unique ID #
2.) Query my SQL Server Database using the ID # supplied and return
results to Word
3.) Autofill fields in the Word document based on the results of the
query executed.

If yes, can someone steer me toward a web-site or resource that gives
instructions to do this.

Thanks!

 

[Cindy M -WordMVP-]

Hi Anthony,

Can I setup a Word document to do this:

1.) When opened prompt user to supply a unique ID #
2.) Query my SQL Server Database using the ID # supplied and return
results to Word
3.) Autofill fields in the Word document based on the results of the
query executed.

If yes, can someone steer me toward a web-site or resource that gives
instructions to do this.

Yes, you can do this. I'd say start with the mvps.org/word site to get
the background you need for putting information into a Word document
and prompting for information. Then it's a matter of using ADO to query
the SQL Server table; do you know any ADO?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[Anthony]

Thanks for the site link.
My background is internet applications using ASP.NET and
SQL Server. I do have a familiarity with ADO. Apart from
typing letters I'm new to Word.
I'll check out that web site and come back with any
questions.

Thanks.

 

[Cindy M -WordMVP-]

Hi Anthony,

My background is internet applications using ASP.NET and
SQL Server. I do have a familiarity with ADO. Apart from
typing letters I'm new to Word.
I'll check out that web site and come back with any
questions.

Good

Given that background, if what you find at the MVP site isn't
enough, you may also want to check out the samples in
WdAcc97.zip that's in the "Special Merges" section of my
website's MailMerge FAQ. As the name suggests, it's a bit old
(and it uses DAO), but it's got a lot of the basic steps you
need.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail