none
How to automatically export a particular sentence from a body email to excel? RRS feed

  • Question

  • This is a preview of my email:

    e-Cop has received news on Application Vulnerability known as "abcdefg".

    Please refer to the information below:

    Date Received:
    01 June 2015

    Severity:
    Medium

    Description:
    adhsjdnkmsdaoidasd

    -----------------------------------------------------------------------------------------------------------------------------------------
    Thus what I only need is the severity only. For example, from every email I received, it will automatically extract only the severity and import it inside an Excel speadsheet. Is it possible? I have neved used VBA before. And one more thing, it should be real time at such that every NEW email is received, it will automatically update the spreadsheet. I hope u guys can help me out in this. Thank you.

    Thursday, July 9, 2015 6:34 AM

All replies