reference image within worksheet in VBA

[yrechtman]

Howdy,
this should be pretty straightforward but how in VBA do i reference an image pasted with an excel sheet? I'm creating an automated email program from a contact list and I insert the body of the email with

.Body = Range("C2").Value & ActiveSheet.TextBoxes(1).Text

Where C2 is the Name of the person and the text box is the the body of the email.

Im trying to stick an image at the end of each email and would rather use an image I've pasted in than have to reference images in my directory (it'll make it easier to reuse this code with other lists).

thanks!

 

[Norie]

I'm not sure you'll be able to use an image from a worksheet.

The usual way to display images in the body of an emain is to use HTMLBody with an img tag whose src attribute refers to an image you've attached.