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.
A1
asdasd
6-Apr-12
4-May-12
6-May-12
23
22222
88%
99.68%
22.85%
9.9999
all the exported text is 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.
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 excel worksheet into a similar table format as the email.
Currently i'm using below code.
Thanks and all your helpp will me much appreciated.
Bookmarks