HELP!.. copy Bitmap of range from Excel to Outlook body

W

WhytheQ

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.
Click to expand...

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

Any help greatly appreciated
Jason
 

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

Bitmap copy of Excel Range into Outlook MailItem. 1
Copy a range from Excel to Oulook MailItem's body as Bitmap 3
copy pasting bitmap into email in lotus notes 0
Cannot copy Excel 2007 Chart and Paste as Bitmap into Powerpoint 2 6
Problem copying table data as a picture onto chartsheet 8
Baffled with assignment of range to array why won't it work??? Anyhelp appreciated 4
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top