Inserting a Word Document as an OLE Object

[Charles Engelhart]

I am attempting to insert a word document (Goals) as a
field into a word document (Master) that I am using as an
active document for a mail merge. I have created a table
in access that includes a field name "Goals" for which I
set the data type as an OLE Object. I then linked this to
the word document "Goals." On the Access table under the
field GOALS it says "Microsoft Word Document." When I
view the content in FORMS, it shows the content of my
document (e.g., "Here are my goals"). Yet, when I insert
the field in my MASTER word document, it inserts the
following: "Long binary or text value." My question is,
how do I make it so that the inserted fields shows the
content (i.e., "Here are my goals." Thank you in advance
for any assistance

 

[John Nurick]

Hi Charles,

I'm pretty sure that you can't mailmerge one Word document directly into
another, and sure that you can't do it the way you're trying, because of
the way Access stores OLE objects: the only easy way of getting at their
contents is via the bound objectframe control you're using on your
Access form.

A better approach might be leave the Word documents as separate files
and store their filespecs (e.g. "C:\folder\filexxx.doc" in your
database. Then merge the filespecs into the Word document and leave it
to Word to handle the documents. I think you can do it like this: in the
Word merge document, use a mergefield to generate the filespec inside an
INCLUDETEXT field.

For more about merging with Word, see http://www.mvps.org/word. If when
you say "Master" document you mean Word's "master document" feature,
read the warnings on the same site: master documents often cause a great
deal of trouble.