copy bitmap to Lotus Notes and email

Hi,

I am trying to copy a range of cells as a bitmap file and copy that
file into Lotus Notes using my macro. Can anyone help me?

This is the offending code:

Range("A1:L36").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
bodytext = ActiveSheet.Paste

At the moment the variable bodytext represents the data I want to
appear in the message. I adapted the code from elsewhere where this was

defined as a string, but i changed it to a variant as string and bitmap

are probably not compatible.


Help help please!


cheers,
David