e-mail sheet in html and attach a spreadsheet

[danwoltrs]

I use Office 365, Windows

I would like to send an e-mail with one sheet as a body html, and another sheet attached to it.

Was able to find online two vba codes by Ron de Buin working on their own, and I was able to merge them together. The only problem I am facing is that the HTML part is coming on black and white, I would love it to come with the conditional formatting, as well as the normal formatting, also, is it possible to include text box and image (logo)?

Please Login or Register  to view this content.

[omahaNative_1023]

what you mean the HTML part is ''coming on black and white''? you mean table is being stripped of formatting you did put yourself into it? there is also stuff wrong with your code i think. this

Please Login or Register  to view this content.

opens file but this

Please Login or Register  to view this content.

i dont think matters in terms of what you want to see in the html body of email. and this

Please Login or Register  to view this content.

is just stream. stream doesnt preserve html code and formats i dont htink. then you put result from that routine in html body with this

Please Login or Register  to view this content.

but you have to know that html table formatting is not the same as table sitting in excel sheet. the < table > element in html has many many css stylings. inline many others. but you can only do inline because html body of email object in outlook can not see external or linked css file. that only for web applications. also, i do not think you need this

Please Login or Register  to view this content.

if you use .htmlBODY property, body format is changed automatically i think. microsoft knows though. but the enumeration is right yes

https://docs.microsoft.com/en-us/off...k.olbodyformat

[danwoltrs]

what you mean the HTML part is ''coming on black and white''? you mean table is being stripped of formatting you did put yourself into it? there is also stuff wrong with your code i think. this

Thank you, yes, it comes out as black and white instead of the colors. I don't know a lot of VBA coding, I google what I want to do, find some results, and try to accommodate to my needs.
Which is why there are a lot of things there that today are unnecessary, but honestly I have no idea what most of the stuff means

I also found a version of a VBA code which prints out the table on mail format perfectly, including the colors and color formatting. For instance negative number red, positive green. Do you know if there's a way to include images?

Here's the other VBA code which works with the colors, but I couldn't get this to work along with the other. It copied the range from a different sheet, and by changing Sheet:=ActiveSheet.Name, to Sheets("Graph") would give me a blank e-mail instead.

Please Login or Register  to view this content.

[omahaNative_1023]

guess i not understand what you need. well are you saying that the table you want in the email you want colors in it? because if that it, no of course it is not going to do that. like I said, html produce colors based on the html code you write. you have to write markup insside the email! you know html markup? they call it 'inline'

[Kenneth Hobson]

You will need to use the WordEditor method to copy/paste a range as a picture rather than htmlBody method. e.g.

Please Login or Register  to view this content.