Send an email from Excel, adding actual workbook, Excel table and text.

Hi all,

This should be an easy one to solve... but I've tried several ways and it still I don't get the desired result...

I have the attached code which adds the actual workbook and also adds an excel table into the email. This works perfect.

The thing is: How can I still add into the email body some text? I've tried the classic: .Body = "xx" or .HTMLBody = "xxx" but it is always "overwritten" by the excel table.

So, which line I can add to my actual code, in order to put an intro in the email body and below add the Excel table without having issues with overwritting?

PS: I'm not looking to change the way I add the Excel table. The way it is pasted into the email is the desired one (I've tried the "wdChartPicture" but I don't like the result.

Thanks in advance for your help!

Please Login or Register  to view this content.