treating pictures as cell contents

  • Thread starter Thread starter Wendy Cutler
  • Start date Start date
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
 
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...
 
Back
Top