Copying Excel table to outlook mail body using macro

[mayura]

Dear All,

Can anyone please help me with a macro to copy the contents of a selected range in an excel table to an outlook mail generated using a macro.

The only thing is that I need the grid along with the formatting of the selected Excel range.

Thanks

 

[afrazier]

That's the next step in the workbook I'm building. If I find a solution before you do, I'll gladly share it.

 

[mayura]

Hi,

Any luck on the above ??

 

[afrazier]

Nothing yet. Sorry. The best I've managed so far is to get Excel to copy a variable range (for when the amount of data changes in terms of rows or columns). It selects it and copies it, but I haven't yet gotten it to auto paste to an email. I'm still doing that part manually.