E-mail sheet range as bitmap

[anar_baku]

Hi all.

I am trying to create a macro that will copy a particular range within one of the worksheets in my workbook and e-mail to specified persons. I have lifted the following code from a friend's old Excel file and have adopted for my own spreadsheet. All is good, except that in its existing form the code pastes the selection as HTML whereas I want to paste it as Bitmap. I am not quite sure what parts of the code I need to amend in the "Converts the range into HTML" section to achieve this. Please help!

Please Login or Register  to view this content.

[anar_baku]

Here is my attempt to revive this unanswered post...

I still haven't managed to figure this one out so your help would be appreciated. Also, if you have another code that achieves what I'm looking for, feel free to ignore my code and just paste yours!

Thanks

[Chippy]

This works for me (Excel & Outlook 2003).

Please Login or Register  to view this content.

If you have Outlook 2007 you might try the techniques shown in http://social.msdn.microsoft.com/For...d-1b7d8061a0ef, which links to http://www.outlookcode.com/d/code/htmlimg.htm (from where I found the cid attribute technique in the last code snippet used in my code).