R
rogedavi
Hi
I have a problem using VBA to send a bitmap (picture would do) in an
email (Lotus Notes).
I have code that does this:
Dim bodytext As Object
Range("A1:L36").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
bodytext = ActiveSheet.Paste
later on...
MailDoc.body = bodytext
But the email does not paste the picture, instead it is just blank?
Can anyone help me?
David
Reply »
I have a problem using VBA to send a bitmap (picture would do) in an
email (Lotus Notes).
I have code that does this:
Dim bodytext As Object
Range("A1:L36").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
bodytext = ActiveSheet.Paste
later on...
MailDoc.body = bodytext
But the email does not paste the picture, instead it is just blank?
Can anyone help me?
David
Reply »