Exporting images to Word via a report

[Guest]

Hi,

I have a table in a database that holds the path to an image file stored on
a hard drive. I have created a query and a report that can display and print
the image (thanks to some assistance from this group). My user now wants the
output saved in a word format - i.e. the details of the record and the image.
I have tried exporting to an rtf from the report but I only get the text
fields and no images. I am also exploring the option of using a word mail
merge to bring the information in but I am then stuck with the same problem.
I can bring the text fields in but not the image - the image is a pathname in
the original table.

Any ideas?

 

[Larry Linson]

I have a table in a database that holds the
path to an image file stored on a hard drive.
I have created a query and a report that can
display and print the image (thanks to some
assistance from this group). My user now
wants the output saved in a word format -
i.e. the details of the record and the image.
I have tried exporting to an rtf from the
report but I only get the text fields and no
images. I am also exploring the option of
using a word mail merge to bring the
information in but I am then stuck with the
same problem. I can bring the text fields in
but not the image - the image is a pathname in
the original table.

As you have discovered, exporting Access Reports to Microsoft Word RTF does
not export the graphics. One way to do this would be to use VBA code to use
COM Automation to create the document in Word. Unless you already have
experience in VBA programming for Word, and know the Word Object Model, plan
on a significant learning curve (as I would have, because I have not
programmed Word in VBA).

I am not certain where you can define the Fields in Word for a mail merge --
thus, not certain if you can fill in the path-and-filename into a Field
defined in Word that would cause the picture to be displayed.

Larry Linson
Microsoft Access MVP