Best Practice for Word Inserts

[ebz]

Hi: I am new to Word and would like a hint for the following situation. I
have a long document with many tables and charts. The document will be
updated automatically when a macro is run from individual .rtf and .xls
files (generated automatically from a DB on a yearly basis). Would it best
to put bookmarks in Word around each item, say, the title of the table or
chart, then replace the table or whatever following? Or maybe put in hidden
text and look for that? Or is there a way to name each table and chart as an
object, look for and replace? Some reports will contain up to 25 different
items to search and replace with new input.
I appreciate your help.

 

[Jay Freedman]

I'll suggest that you use IncludeText and IncludePicture fields in the Word
document. Each field's code includes the name of the file from which to
bring in the information. If every run of the DB uses the same names for the
files, all you need to do is open the Word document and update the fields to
get the new data. If the filenames change, your macro can modify the field
codes accordingly.

If the finished document needs to be sent electronically to others, as
opposed to being printed only, then you'll need to unlink the fields before
sending them. That makes the field results into actual text/graphics in the
document rather than just links.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[ebz]

Thanks- appreciate the help. I will give it a try.