treating pictures as cell contents

W

Wendy Cutler

I'd like an excel spreadsheet to have some columns whose contents are
pictures. Then I'd like to do a mail merge in Word, using data from the
spreadsheet, and when I have a merge field for each of the columns that have
pictures, I'd like the pictures to appear in the merged document, just like
the data fields appear. Excel doesn't seem to consider the cells with the
pictures as containing any data. Is there a way to have those pictures
identified as cell data?
+*+
Thanks,
Wendy
 
J

JE McGimpsey

No, pictures always exist on the drawing layer "above" the cell grid.

You could instead perhaps include the path and filename of the picture
in the cell underneath the pic, and use that in a merge, then use a
macro to retrieve the pic in Word...
 
Top