move email (outlook) body to excel

[abdullabf]

hi ,
need your kindly help with this ...
I always have the same email bode text as..
------------

IDM - 6000765610 > Confirmed

Expected Action: Pay

Amount: 147.00 USD
Issue Date: 06Sep18
Related Document(s): 000-0000000000
Reason Code: XXXX1
Reason Text: text

Memo raised against:
Agent Sign: 0000xx


----------------------------------
I want to extract the data automatically to excel , and also for the STATUS which is Confirmed as the example, update automatically if I receive a new email with the same IDM number and lets say its updated to be DELETED.

I have an old VBA I used it manually to move from outlook to excel

Please Login or Register  to view this content.