none
Export Specific Test from multiple mails to excel Sheet RRS feed

  • Question

  • First Thing I don't know about VBA or Access form creation or anything. I am simply searching for a way to fetch specific data  from the body of my emails to Excel. The mail body is in the following format:

    This resume has been forwarded to you at the request of Monster User XYZ123

    Some one's name

    Last updated:  01/10/16

    Job Title:  no specified

    Company:  no specified

    Rating:  Not Rated

    Screening score:  no specified

    Status:  Resume Received

    Some Place,FL  34586 US

    Mobile: 9523545411    Home: 4454548745 someone@gmail.com

    Quick View Links:

    Summary Section

     

     

    RESUME

      

    Resume Headline: Some One' Name - Network/Desktop Support

    Resume Value: 00000  

      

     

    Experience

    BACK TO TOP

     

    Job Title

    Company

    Experience

    Network/Desktop Support

    IBM

    - Present

    Above mail seems have tables, and i want to Export only Name, Address, Mobile, E-Mail ID (for this if assume line 2, 10,11,12)

    I would be glad and appreciate it some look into this and give some easy solution

    Thanks in advance


    sultan



    • Edited by sultan.ms Wednesday, January 13, 2016 5:31 PM
    Wednesday, January 13, 2016 5:29 PM