none
Extract outlook or OWA message email details into Excel sheet and auto save file onto my desktop RRS feed

  • Question

  • Hello,

    Please help me i want to Extract outlook from inbox or OWA message email details into Excel sheet and auto save file onto my desktop.

    Email body message below:

    EMAIL RECEIVED TIME: Thu 12/17/2015 1:54 PM

    FINAL LOADING ADVICE--EDI FOR LDF            

    OPERATOR:WINSMART            

    DATE: 2015-12-17           
    VSL/VOY: KTR/5514(YUE HONG JI 369)           

    LIGHTER(deliver to CNNANCT):HUI WAN
    302 V.516601512170 [5514]
    <o:p></o:p>


     
    Barge Op Ref No: 151217/Domestic            

    APPOINTMENT TIME :2015-12-19(08:00 HOURS)      


    POL:CNZHQWM(ZHAOQING)       

    POD:CNNANCT(NANSHA GOCT)            

    TTL:3X20GP&2X40HQ&1X45HQ ( 6 UNITS)

    I want above details into extract this mail body details into Excel sheet column as below:

    POL POD 20GP 40HQ 45HQ VSL VOY VSL/VOY NAME OPERATOR LIGHTER APPOINTMENT   TIME Barge Op Ref No EMAIL RECEIVED   TIME
    CNZHQWM CNNANCT 3 2 1 KTR 5514 YUE HONG JI 369 WINSMART HUI   WAN 302 12/19/2015   8:00 151217/Domestic 12/17/2015   13:54

    Thanks,

    Subhash Amate

    Sunday, December 20, 2015 2:34 PM

All replies

  • This issue comes up every few weeks and a check of the links listed alongside should show the way.

    The process is collated at http://www.gmayor.com/extract_data_from_email.htm.

    You could also investigate http://www.gmayor.com/extract_email_data_addin.htm


    Graham Mayor - Word MVP
    www.gmayor.com

    Monday, December 21, 2015 9:37 AM
  • Hello,

    Please give change in coding as per above my data ....?

    Thursday, December 24, 2015 6:47 AM
  • Hello, Please help me i want to Extract outlook from inbox or OWA message email details into Excel sheet and auto save file onto my desktop

    I don't understand actual..?

    Monday, January 4, 2016 6:48 AM
  • please give coding for above example...?
    Monday, January 4, 2016 6:48 AM