copy pasting bitmap into email in lotus notes

R

rogedavi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save sheet bitmap to desktop? 6
copy area on spreadhseet as picutre 5
Bitmap copy of Excel Range into Outlook MailItem. 1
Carriage Return and Splitting Lines to Lotus Notes Msg through VBA 3
Cannot copy Excel 2007 Chart and Paste as Bitmap into Powerpoint 2 5
Ron, I found some code that works with Lotus Notes 5
Lotus Notes CreateObject 1
runtime error 91 2

Top