Send a mail with a macro in Excel & keep the conditional formatting + picture in the body

Hello everyone,

First of all I'm new to this forum.

I'm struggling with something, so I need your help on this.

I have an excel which first of all generates some KPI's through a macro run on other data in the excel. These KPI's are calculated and put in a table with a fixed layout.
Everyday these KPI's are calculated. To make this a bit more user-friendly and less time consuming I needed to automate this excel. The table with the KPI's needs to be send everyday to several people.

I already managed to send the table with - let us say - the standard VBA-code, but the problem is that this code does not copy the conditional formatting I use in this table. The conditional formatting I use is a icon set based on the values in the cells.
I already searched the web and found alternative methods like with HTML, but none of these work so far.
There is also a picture in this table which needs to be included into the body of the mail. I also found a way to solve through an attachment in the mail, but it needs to be in the body of the mail. If you try it manually copying the table and open a new mail and paste as picture then it works, the problem is to get this automated.

Is there anyone who could help me with this??

Hi Fred

Pictures are of little value. Attach a File that is of the same structure as your actual file...change any proprietary information.

Is your Email Client Outlook?

Hi Fred

Try this Code...it appears to work as required...run MailTest

Please Login or Register  to view this content.