Importing variable images into a mail merge

[McFox]

Using Word and Excel 2003, I need to import a number of different jpeg files
into the mail merge.
Ideally the image would be a field and then linked into the main document.
Is this possible, or alternatively could Access be used for the same
purpose? If the latter, how do you place a jpeg file in Access, to pull
through into a Word document?

Thanks.

 

[Peter Jamieson]

Save each jpg as a separate file with a pathname that can be constructed
from data in your Excel sheet.

e.g. if all your jpgs are in

c:\myjpegs\

then you can put the file name (mypic1.jpg etc.) for each image in a column
in the appropriate row in Excel. Let's call the column "jpgfile"

Then use the following nested Word fields in your Mail Merge Main Document:

{ INCLUDEPICTURE "c:\\myjpegs\\{ MERGEFIELD jpgfile }" }

(all the {} have to be the special field codes you can enter using ctrl-F9.
notice that the folder pathname backslashes are doubled up. Ensure you don't
have any spaces that should not be in the full path name of the file)

Merge to a new output document, select it (e.g. ctrl-A) and press F9 to
update all the images.