Mail Merge Pictures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robin - 03 Aug 2004 18:46 GMT

We want to send a letter to our current parents with their
child's picture on it. My data source is an Excel file.
In the "Photo" column I have a hyperlink to the location
of the photo. Is there anyway to merge this data source
with the letter in Word and have the hyperlink actually
display the appropriate photo instead of just text (not
even a hyperlink) to the location the photo is saved at?

Reply to this Message

Peter Jamieson - 03 Aug 2004 21:40 GMT

As a generalrule you need to use a nested field such as

{ INCLUDEPICTURE "{ MERGEFIELD photolocation }" }

All the {} need to be the special field code braces you can insert using
ctrl-F9

However, you will need to test this as, e.g.
a. Word may not be able to retrieve the picture if, for example, the
hyperlink is to a web address rather than a Windows file system folder
b. Word won't work with all types of photo (e.g. .jpg is probably OK), and
you may find it difficult to get the photo to be the size you want
c.you may need to output the mailmerge to a new document, then select it
and press F9 to update the links, to see the photos. Then you'd probbaly
have to split the document up if for example you were e-mailing one to each
set of parents.

Signature

Peter Jamieson

> We want to send a letter to our current parents with their
> child's picture on it. My data source is an Excel file.
[quoted text clipped - 3 lines]
> display the appropriate photo instead of just text (not
> even a hyperlink) to the location the photo is saved at?

Reply to this Message

Graham Mayor - 04 Aug 2004 08:33 GMT

See 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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Reply to this Message

Rate this thread: