View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default HELP!.. copy Bitmap of range from Excel to Outlook body

hi
see this site

http://www.rondebruin.nl/sendmail.htm

regards
FSt1

"WhytheQ" wrote:

Ok - here we go:

I've got my formatted numbers in Sheets(1).Range("A1:D18").
If I run the following

Sheets(1).Range("A1:D18").CopyPicture xlScreen, xlBitmap

then activate an empty Outlook MailItem.
then do control v, the data appears in the email in Bitmap format, which is what I want.


How do automate all of the above - preferably without using the
SendKey method?

Any help greatly appreciated
Jason