Is this possible.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony - 15 Dec 2003 17:26 GMT

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!

Reply to this Message

Cindy M -WordMVP- - 16 Dec 2003 14:25 GMT

Hi Anthony,

> Can I setup a Word document to do this:
>
[quoted text clipped - 6 lines]
> 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 :-)

Reply to this Message

Anthony - 16 Dec 2003 19:02 GMT

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.

>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
[quoted text clipped - 10 lines]
>
>.

Reply to this Message

Cindy M -WordMVP- - 18 Dec 2003 17:25 GMT

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 :-)

Reply to this Message