Merging Pictures into reports.

[Gus]

I have completed a factory inspection and recorded issue
details in an excel spreadsheet. A Word document then
merges the issue details into formatted reports.
In addition to the details of each issue there is a photo
(jpg) that I would like to insert or better still link
into the merged word document. The picture file names are
in a column of the excel spreadsheet (Also as Hyperlinks),
and the files are located in the same directory as the
excel and word files.
Can any one offer any suggestions?

This nature of inspection and report will be an on going
thing.

Thanks Gus

 

[Mike]

Gus,

You can create an INCLUDEPICTURE field that incorporates a MERGEFIELD field:

{ INCLUDEPICTURE { MERGEFIELD IMAGE_LINK \* MERGEFORMAT } \d \*
MERGEFORMAT }

Note: use \d to tell Word not to store the picture with the document (i.e.
hyperlink it).

Regards,

Michael Cessna

 

[Doug Robbins]

See the "Graphics from database" item under the "Special merges" section of
fellow MVP CIndy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Graham Mayor]

See also - http://www.gmayor.com/mail_merge_graphics.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>