I've done SQL/Word integration before, but it was a "closed"
solution using client-side VBScript and it did not create labels,
but instead populated contract templates via bookmarks. This
type of solution is really only valid for an intranet...where you
have complete control of the computers that are using the code.
The sample code is too much to post here, so email me directly
if you think it would help get you started.
garth at sqlbook dot com
"Jesse Johnson" <Je**********@discussions.microsoft.com> wrote in message
news:4E**********************************@microsof t.com...
I would like to stick with WORD so that we would be able to edit and format
if needed. I was wondering if there would be any way? Seems like a
complicated project.
--
Jesse Johnson
"Bruce Barker" wrote:
the most reliable way is to produce a pdf file. look at any reporting
package.
-- bruce (sqlwork.com)
"Jesse Johnson" <Je**********@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...I have kind of a complicated issue. I need to be able to have someone come
to
our online application and simply hit "Create Labels" from there idealy
Microsoft Word would pop up and all of our records from the SQL Server
would
be inserted into a special Avery template. I dont know where to start.
could
anybody point me into the right direction? Any help would be wonderful.
Thanks in advance.
--
Jesse Johnson