Export Outlook 2010 emails content message body with table in it to Excel

[Andywsw]

Hi all,

I would seek solution or ways to export table in outlook 2010 message body with the whole table arrange in a table format in excel excatly as the way the emails shows.

Right now for my current situation is that i manage to export the whole message body over to excel however is that i have this problem that in one cell ( like in cell A1) containing one whole text , values , numbers and dates.


------A
--|__________ |
1 |asdasd
--|16-Apr-12
--|14-May-12
--|16-May-12
--|23
--|22222 abcd
--|88%
--|99.68%
--|22.85%
--|9.9999
--|__________
2 |
--|
--|
--|

FYI,Right now they are in warp text format(as above). And if i unwarp it , it will form into a long string of words without spacing (like xxxxxxx22-323xxxxxx-asdfas99.68%22.85%) is it possible to shift each line ( as above ) into a table format.

-----A -----------b----------- c
|________ | __________| __________ | .....

1 | asdasd | 16-Apr-12 | 14-May-12 | .....

 

[Andywsw]

bascially what i am trying to do is extracting the email in outlook with a table containing data and export the data from the table into specifc cells on an excelworksheet into a similar table format as the email

Need some advice ! thanks !