Report

[Skc]

I have a database which also contains the filename to an image, e.g.
image.jpg. What I want to do it create brochures, so I can do a mailmerge -
merge all the fields from the table into this page and also display an image
on the page based on paths to the filename in a particular directory.

So if my record has image.jpg, then I can modify this on the mailmerge so
that it becomes c:\pictures\<<database image field>>.

Do I use Word for this or Access? How do I do this and what are the pros
and cons for doing this between Word and Access?

thanks.

 

[Beth Melton]

If your database field is a text data type and contains the filename,
rather than an OLE data type and contains a linked/embedded image then
Word would work best. If they were embedded/linked images then an
Access report would work best since Word does not support the OLE data
type in mail merge.

You're almost there, however you need to nest your merge field in an
IncludePicture field. It would look something like:

{ IncludePicture "C:\\Pictures\\{ MERGEFIELD DatabaseImageField}" }

Note the double backslashes in the path. To insert the field braces
({ }) press Ctrl + F9.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/