+ Reply to Thread
Results 1 to 1 of 1

Extracting mail message(outlook) table in the message body

  1. #1
    Registered User
    Join Date
    04-09-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    54

    Extracting mail message(outlook) table in the message body

    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 !
    Last edited by andywsw; 06-12-2012 at 10:33 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1