Need Help: Using Includepicture to display graphics in mail merges

[Michael Weber]

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?

 

[Doug Robbins]

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.

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

 

[macropod]

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

 

[Graham Mayor]

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

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


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

 

[Graham Mayor]

Mailmerge? You mean Mergefield

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


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

 

[Michael Weber]

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!

 

[Graham Mayor]

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

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


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

 

[macropod]

touché!

Mailmerge? You mean Mergefield

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


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

 

[Michael Weber]

Tables worked like a charm. Thanks!