Hi guys
i need good advice on extracting mail message(outlook)containing table in the message body
an example of each mail body : ( X - text )
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
< TABLE with 11 ~ 12 columns and 2 or more rows >
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxXXXXXXXXXXXXXXXX
Xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Few things to take note:
1) The table row and column may varies with different sender but the text table text format is the same
2) i need to extract only the table in the message body and arrange all similar email with this format so that all the tables from different mails are complied together into excel
3) What i have done is that i am able to extract the mails to excel but not sure what next
4) Also u may wondering why the columns may varies because some sender might put remarks and some might not
|Cheers !
Bookmarks