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 8
Save sheet bitmap to desktop? 6
copy pasting bitmap into email in lotus notes 0
loading a bitmap into an image control from the clipboard 4
Best format to export Excel Range to picture?? WMF?? 5
Problem copying table data as a picture onto chartsheet 6
Macro to Paste Picture in email body from Clipboard 4

Top