Insert Excel Range into Outlook Message

[satania]

Hello All,

I'm trying to insert a range of excel data into an email message. The macro I have looks for a mail item and downloads the attachment. Then it copies that data into another excel and sets up a report. The report is small and I want to copy/insert that into a mail message and send it to others. Everything in my code works except inserting the range. I'm using the html method, copying the range into an html document, then reading that back into the mail message, but it always shows up as a blank email. Any suggestions? Below is my code. The html stuff is at the bottom of the code, the first half is just copying data and inserting formulas.

Please Login or Register  to view this content.

Thanks for any help anyone is able to give!

[satania]

Any have any ideas? Below is the code snippet I'm having issues with. It just shows a blank email/html document when I do this. And I'm sure there is data in the range I am copying.

Please Login or Register  to view this content.

[satania]

I figured it out. I don't think the html thing works when running the macro in Outloook. I am using an html table now. I set message = "<table>" etc, filling in the rest of my table data i need to copy.

[mackypogi]

hi satinia, can you share the complete codes?

thanks