Why do table conditional formatting icons disappear when copy/paste table into outlook message or when emailed via send selection (VBA)?

Question

I have a workbook that pulls data from a data mart. 

One of the fields displays a value of 0 or 1 or 2. 

I place conditional formatting on these fields to use an icon set that displays a checkmark, red X, or yellow ! depending on the value in the cell.

I choose to only display the icons, since the data means nothing to the report users.

When I copy/paste the table into Outlook the icons vanish and the cells are blank.  The whole point was to email a report with checkmarks in the column!

The same thing happens when I email the table selection via VBA.  The email arrives in Outlook with a table that has blank columns rather than the conditional formatting icons that I set up.

Does anyone have a solution?

Answer 1

In that case, your only other option is to Paste Special.../Microsoft Excel Worksheet Object.  That will retain everything, but now you have an embedded object in your email, which means more overhead and a larger email.

And very likely your mail service will convert that to a picture anyway.

Answer 2

Perhaps you are reading too much into the word "picture"  What would appear in the email message is a graphical representation of the Excel table.

and I am telling you that it is not acceptable.

Answer 3

If the recipients don't need to manipulate the data, but only see it, you could paste it in as a picture instead of a table.  Just do a Paste Special and select Bitmap or Picture.

Eric

Sorry, but we can't be sending pictures.

Thank you,

Bill

Answer 4

Perhaps you are reading too much into the word "picture"  What would appear in the email message is a graphical representation of the Excel table.

Answer 5

If the recipients don't need to manipulate the data, but only see it, you could paste it in as a picture instead of a table.  Just do a Paste Special and select Bitmap or Picture.

Eric