>-----Original Message-----
>Our Legal department gives each of its important
>documents a unique ID for tracking purposes. A SQL
>database is used to store the tracking data and a ASP web
>application is used to front-end it all.

>The most important ASP page in the web app is used to
>start tracking a new document. Once this page has been
>filled out, the unique ID for the document is created and
>the data stored.

>What we'd like to do is "call" that page from within Word
>and, when the data is written, we want Word to be able to
>get the unique ID and be able to use it.  (In the page
>footer, for example, or as the document's file name.)

>Does anyone think this can be done and, if you do, could
>you maybe point me in the right direction?

>Thanks...
>Peter
>.

>-----Original Message-----
>Hi Peter,

>Some of the MVPs in this forum will be able to give you
>more specific information, but you could try looking in
>Word VBA help for a "OpenDataSource" Method, this will
>retreive data from an SQL server source. From here you
>could write some code to propogate the information into
>the document you are writing

>Hope this little snippit of information might help.
>Otherwise those clever MVPs will definately be able to
>point you in the right direction :)

>Good luck

>Markie

>>-----Original Message-----
>>Our Legal department gives each of its important
>>documents a unique ID for tracking purposes. A SQL
>>database is used to store the tracking data and a ASP
web
>>application is used to front-end it all.

>>The most important ASP page in the web app is used to
>>start tracking a new document. Once this page has been
>>filled out, the unique ID for the document is created
and
>>the data stored.

>>What we'd like to do is "call" that page from within
Word
>>and, when the data is written, we want Word to be able
to
>>get the unique ID and be able to use it.  (In the page
>>footer, for example, or as the document's file name.)

>>Does anyone think this can be done and, if you do,
could
>>you maybe point me in the right direction?

>>Thanks...
>>Peter
>>.

>.

>-----Original Message-----
>Thanks, Markie:  It's a good idea you've offered, and I
>can see the possibilities.  I could post the key I want
>to SQL, then have Word go and get it.

>BUT...  I'm still stuck for how to invoke the .asp from
>within Word, and then to know that .asp has completed so
>I can go for the key using OpenDataSource.

>So, MVPs, if you've go an idea it would surely be
>appreciated.

>Thanks again, Markie...

>>-----Original Message-----
>>Hi Peter,

>>Some of the MVPs in this forum will be able to give you
>>more specific information, but you could try looking in
>>Word VBA help for a "OpenDataSource" Method, this will
>>retreive data from an SQL server source. From here you
>>could write some code to propogate the information into
>>the document you are writing

>>Hope this little snippit of information might help.
>>Otherwise those clever MVPs will definately be able to
>>point you in the right direction :)

>>Good luck

>>Markie

>>>-----Original Message-----
>>>Our Legal department gives each of its important
>>>documents a unique ID for tracking purposes. A SQL
>>>database is used to store the tracking data and a ASP
>web
>>>application is used to front-end it all.

>>>The most important ASP page in the web app is used to
>>>start tracking a new document. Once this page has been
>>>filled out, the unique ID for the document is created
>and
>>>the data stored.

>>>What we'd like to do is "call" that page from within
>Word
>>>and, when the data is written, we want Word to be able
>to
>>>get the unique ID and be able to use it.  (In the page
>>>footer, for example, or as the document's file name.)

>>>Does anyone think this can be done and, if you do,
>could
>>>you maybe point me in the right direction?

>>>Thanks...
>>>Peter
>>>.

>>.

>.