[dba-Tech] Word Tables and Bookmarks Question

Arthur,

You can try 4TOPS WordLink Add-in http://www.4tops.com/wordlink.htm 
(shareware - 30 days free trial). It does what you need and much more
http://www.4tops.com/word_mail_merge_examples.htm

You can find it uses MS Word quote fields as place holders and bookmarks.
For tables you just have one row definition and insert as many rows as you
need on runtime but without quote fields/bokmarks - the first row keeping
definition fields and bookmarks is good enough to calculate the cell for
subsequent rows' fields.

Nothing complicated but programming of all that is rather time consuming...

Shamil

----- Original Message ----- 
From: "Arthur Fuller" <artful at rogers.com>
To: "Discussion of Hardware and Software issues"
<dba-tech at databaseadvisors.com>
Sent: Friday, May 20, 2005 1:45 AM
Subject: [dba-Tech] Word Tables and Bookmarks Question


> I haven't tried to do this before, but before I begin I thought I'd run
> the question past this most esteemed group.
>
> Assume a Word template (.dot) containing a table. This table contains
> bookmarks which are filled from an Access app using code that finds the
> bookmarks and stuffs text into them.
>
> This works fine for individual bookmarks, but what if the table has
> multiple rows. How do I distinguish them? Often the query in Access will
> return only one row, but sometimes it might return say 10 rows. Then
> what do I do? Am I going about this in completely the wrong way, using
> bookmarks? Should I be thinking of a completely other approach, such as,
> I don't know, maybe embedding an Excel sheet in place of the table and
> drawing the data from SQL into the sheet first?
>
> Perhaps I should mention that the whole reason for doing this is that
> the document must be saved to a unique name and be editable. So I start
> with a Word template, programmatically create the document, then offer
> the user the option to edit the document or save it for editing later
> on. The client ideally would like to do the data entry, have the app
> create the document at once, make the usual edits, save and print it,
> and give it to the client on the spot.
>
> TIA for your suggestions,
> Arthur
>
> >
> >
>
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.322 / Virus Database: 266.11.12 - Release Date: 5/17/2005
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com