copying outlook to excel

[mubaraklax]

Hi,

I am a newbee to this forum and i need your help. I need to copy only the table from outlook body to excel. Then i have to check particular column and copy & paste that row to outlook email body from excel including header row(i.e. with first row of excel). All these to be done from outlook vbe editor. I would be greatful some one please help me with this..

[mubaraklax]

Could someone please help me on the above?

[mubaraklax]

Hi,

Could someone please help me on this. I have got code to copy entire email body to excel. But not only the table.

[JP2112]

To copy a table in an email body, try this code:

http://stackoverflow.com/a/8069282/190829

[mubaraklax]

Hi JP,

thank you very much for your help.
I tried the code and getting the error "Subscript out of range" in line
ReDim headerRow(1 To numberofColumns).