Mail Merge with Picture file name included in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

crazymfr - 27 Jun 2007 19:20 GMT

I want to import graphics from a fixed location into a word document.

I have the file name and path referenced for each record in my data sheet.

I can't seem to get the INCLUDE PICTURE field in Word to work properly, or
at all.

Please help, I don't understand the references I've seen in other posts.

Only the path\file.extension of each picture is listed in my data.

Please help.

Thank you.

Reply to this Message

Doug Robbins - Word MVP - 28 Jun 2007 03:34 GMT

I do not know to what other references you are referring, but
See the "Graphics from data base" item under the "Special merges" section of
fellow MVP Cindy Meister's website at

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

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I want to import graphics from a fixed location into a word document.
>
[quoted text clipped - 10 lines]
>
> Thank you.

Reply to this Message

crazymfr - 28 Jun 2007 13:20 GMT

Can't get the INCLUDEPICTURE Field in Word to work.

Tried using this: http://homepage.swissonline.ch/cindymeister/MergFram.htm

I was able to pull the file name and path, but it doesn't seem to work. Any
idea? I have a post into MS now, but they haven't replied yet.

I think my syntax is off. This is what I used:

{ INCLUDEPICTURE "{MERGEFIELD "Logo"}"}

{MERGEFIELD "Logo"} is the field in my spreadsheet where the file name and
path are located which I pulled from a shared drive.

I think it may be that the field won't allow me to reference the whole path
location and name for the INCLUDEPICTURE Field to work. Not sure though.
Most suggestive posts are referencing catalogs or directories. I did try the
double \\ insertion and this does not get it done. Still looking for help.

> I do not know to what other references you are referring, but
> See the "Graphics from data base" item under the "Special merges" section of
[quoted text clipped - 16 lines]
> >
> > Thank you.

Reply to this Message

Graham Mayor - 28 Jun 2007 15:39 GMT

See if http://www.gmayor.com/mail_merge_graphics.htm makes things any
clearer.

Signature

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

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

> Can't get the INCLUDEPICTURE Field in Word to work.
>
[quoted text clipped - 49 lines]
>>>
>>> Thank you.

Reply to this Message