Need Help: Using Includepicture to display graphics in mail merges

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Weber - 10 May 2005 18:18 GMT

Here is the situation:

I have an Excel worksheet as the data source and have a Word merge document
to display the information. We have just added some renders of the items and
I would like to add the graphics to the word merge document. I have tried to
use the {includepicture “{image}”} command to display the images at the paths
specified in the Excel worksheet but have had no luck in doing so.

The command I am using is: {includepicture “<<image>>”}.

The <<image>> field in the Excel sheet has a full path to the filename
(c:\\dir\\file.jpg). Whenever I add this command and attempt a merge it
simply deletes the command in my merge template. I have followed the
instructions in both of the primers that are commonly cited and have finally
hit my frustration level. At this point I’m losing time trying to get this
working and would have been better off actually typing the documents by hand
and pasting in the photos. Of course that isn’t a scalable solution like that
one I envision and I would like to get this working.

Does anyone have any suggestions?

Signature

Michael Weber

Reply to this Message

Doug Robbins - 10 May 2005 21:48 GMT

Did you use Ctrl+F9 to insert the field delimiters { }?

Have you tried doing a Ctrl+a (select all) and then F9 (update fields) on
the document created by executing the merge.

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

> Here is the situation:
>
[quoted text clipped - 23 lines]
>
> Does anyone have any suggestions?

Reply to this Message

macropod - 11 May 2005 11:55 GMT

Hi Michael,

The correct syntax would be:
{INCLUDEPICTURE "{MAILMERGE ImageName}"}
where the field braces (i.e. '{ }') are created in pairs via Ctrl-F9 and
ImageName represents the full image path (including the drive), plus the
filename and extension.

If Excel only holds the filename and extension, you'd express the field as:
{INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}"}
or
{INCLUDEPICTURE "C:\\My Documents\\Images\\{MAILMERGE ImageName}.jpg"}
if Excel only holds the filename. Use your own drive and path, of course,
with *double* backslashes as separators (though you can use single forward
slashes instead) and, in the last example, specifying the file type.

Cheers

> Here is the situation:
>
> I have an Excel worksheet as the data source and have a Word merge document
> to display the information. We have just added some renders of the items and
> I would like to add the graphics to the word merge document. I have tried to
> use the {includepicture "{image}"} command to display the images at the

paths

> specified in the Excel worksheet but have had no luck in doing so.
>
[quoted text clipped - 7 lines]
> working and would have been better off actually typing the documents by hand
> and pasting in the photos. Of course that isn't a scalable solution like

that

> one I envision and I would like to get this working.
>
> Does anyone have any suggestions?

Reply to this Message

Graham Mayor - 11 May 2005 14:15 GMT

Mailmerge? You mean Mergefield :)

Signature

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

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

> Hi Michael,
>
[quoted text clipped - 40 lines]
>> --
>> Michael Weber

Reply to this Message

macropod - 12 May 2005 00:22 GMT

touché!

> Mailmerge? You mean Mergefield :)
>
[quoted text clipped - 42 lines]
> >> --
> >> Michael Weber

Reply to this Message

Graham Mayor - 11 May 2005 14:14 GMT

See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do
this.

Signature

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

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

> Here is the situation:
>
[quoted text clipped - 18 lines]
>
> Does anyone have any suggestions?

Reply to this Message

Michael Weber - 11 May 2005 16:10 GMT

Thanks for the help. I did follow the instructions at the site prior to
posting a note here. It appears my problem stems from the use of a test box
to display the image in. Once I formatted the document to not use a test box
for the image location I was able to get it working just fine.

Does anyone have advice on how to get this working inside a text box so I
can have finer control of the location of the graphic?

Thanks again!

Signature

Michael Weber

> See http://www.gmayor.com/mail_merge_graphics.htm which explains how to do
> this.
[quoted text clipped - 21 lines]
> >
> > Does anyone have any suggestions?

Reply to this Message

Graham Mayor - 11 May 2005 16:42 GMT

Use a table cell instead. Text boxes are not in the text plane of the
document and so fields they contain are problematical.

Signature

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

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

> Thanks for the help. I did follow the instructions at the site prior
> to posting a note here. It appears my problem stems from the use of a
[quoted text clipped - 40 lines]
>>>
>>> Does anyone have any suggestions?

Reply to this Message

Michael Weber - 13 May 2005 18:46 GMT

Tables worked like a charm. Thanks!

Signature

Michael Weber

> Use a table cell instead. Text boxes are not in the text plane of the
> document and so fields they contain are problematical.
[quoted text clipped - 43 lines]
> >>>
> >>> Does anyone have any suggestions?

Reply to this Message