treating pictures as cell contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy Cutler - 11 Aug 2007 07:44 GMT

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

Reply to this Message

JE McGimpsey - 11 Aug 2007 14:32 GMT

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

> 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
[quoted text clipped - 6 lines]
> Thanks,
> Wendy

Reply to this Message