Merging Graphics into Word Documents from Excel

P

PCOTCKHS

I wish mail merge graphics in Word from Excel. The field name in Exel is
Photos. Each cell has the full path to the picture file stored on C: I have
made several attempts without success. Any assistance would be appreciated.
 
G

GTS

PCOTCKHS said:
I wish mail merge graphics in Word from Excel. The field name in Exel is
Photos. Each cell has the full path to the picture file stored on C: I have
made several attempts without success. Any assistance would be
appreciated.

You would use the INCLUDEPICTURE fieldcode, but you put the full path to the
picture in this field so would not need it in the excel file - so assuming
that all your pictures are in say C:/pictures the INCLUDEFIELD field would
be as follows:
{ INCLUDEPICTURE "C:\\pictures\\{Photos}.jpg" /d }

So Photos is the mergefield, and the /d is optional - this prevents the
graphic from being saved with the document if you want to keep the file size
down.
Graham
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top