none
export data from email messages outlook 2007 to excel 2007 RRS feed

  • Question

  • i am receiving daily reports with following format on the body of the mail message. i am trying to find a code for automatic export to a worksheet in excel. can anybody help me to do so?

                                                                                                                                                                  

                                                                                                                                                                                    

    NOON REPORT                                                                                                                                                                                                                          

                                                                                                                                                                                                                                                            

    1. DATE/ TIME (Local-UTC):

    01/JAN/14      (1200  – 2100) 

      2. Condition(Ballast/Laden) :

    BALLAST

      3. Voyage (From/To) :

    SAKAIDE TO SAN FRANCISCO

      4. ETA Next Port (Basis C/P-ECO speed):

    03 JAN 14    PM

      5. Latitude/longitude:

    3827N / 13704W

      6. Course:

    090

      7. Wind Direction & Force :

    SSW/4

      8. Swell Direction / Height meters :

    WNW/03

      9. Currents speed & Direction :

    VAR/0.5  KNOTS

    10.  Maneuvering handle:

    75

    11.  RPM :

    75

    12.  Steaming Time (Hours) Since Last Report (NM):

    24-00

    13.  Distance Sailed Since Last Report (NM) :

    308

    14.  Distance to Go (NM) :

    700

    15.  Distance Run by engine in (NM) :

    291

    16.  Speed (knots) :

    12.8

    17.  Slip %(+/-):

    -5.8 %

    18.  Total Distance Sailed Since Departure (NM):

    4514

    19.  Total Steaming Time (Hours) since Departure:

    374-00

    20.  Total Average Speed (knots) Since Departure:

    12.1

    21.  M/E Daily Consumption :

    HSFO 22.0  MT     (24-00 HRS)

    22.  D/G Daily Consumption / No. of Working D/G’s  /               HSFO   3.0   MT / (No1+NO3)   

    If Working more than 1 D/G, reason :                                        GSP RUNNING

    23.  Boiler Daily Consumption :

    00

    24.  Incinerator Daily Consumption (Diesel oil in Ltrs):

    60

    25.  Cylinder oil daily consumption:

    165 LTR

    26.  Bunkers ROB in MT and cont. of sulfur %

    HSFO:

    937.2  (2.28)    

    LSFO:

    142.5     (0,26%)

    MDO:

    0.0

    LSGO:

    25.0      (0.1%)

    F.W:                                                                       300 MT           

    LUBS (ME – CYL – D/G):

    13500 – 8015– 6400

    27.  Others/Remarks :

    Thursday, January 2, 2014 9:44 AM