Multiple Ranges As Pictures In Outlook Body

[Frenzyy]

Hey All, I've got working code which takes a range from excel and pastes it into the body of a newly created email. What I now need though is to be able to attach two different ranges as pictures into that same email. I tried various ways but nothing seems to work and I'm currently stuck with pretty much two the same functions and the email not even displaying now. Surely, I must be doing something wrong and missing something obvious, since it must be possible to do this.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

HTML tags are with spaces due to forum rules.

Many thanks!

[vba_php]

I have not reviewed any of your code, but based on the fact that you said this:

What I now need though is to be able to attach two different ranges as pictures into that same email.

you do know that images, when in excel, are generally in there in the form of embedding, right? and if they are, they are part of the shapes collection. and thus, can be referenced in code with the following properties (along with various methods/functions too):

Please Login or Register  to view this content.