Merging Pictures into reports.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gus - 14 Jul 2004 00:53 GMT

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

Reply to this Message

Mike - 14 Jul 2004 01:09 GMT

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

> I have completed a factory inspection and recorded issue
> details in an excel spreadsheet. A Word document then
[quoted text clipped - 11 lines]
>
> Thanks Gus

Reply to this Message

Doug Robbins - 14 Jul 2004 03:32 GMT

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

Signature

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

> I have completed a factory inspection and recorded issue
> details in an excel spreadsheet. A Word document then
[quoted text clipped - 11 lines]
>
> Thanks Gus

Reply to this Message

Graham Mayor - 14 Jul 2004 05:42 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have completed a factory inspection and recorded issue
> details in an excel spreadsheet. A Word document then
[quoted text clipped - 11 lines]
>
> Thanks Gus

Reply to this Message

Rate this thread: