copying email body text to xl

  • First time - be gentle please..
    I would like to copy data from the body of emails into Excel
    (Data in email always comes in same format), e.g.


    Joe Bloggs



    Ref No:


    I would like only the data on RHS to be input into next empty row in my spreadsheet so that joe bloggs is in cell A1, the date is in B1 etc, etc

    Any ideas?
    Any constructive help appreciated

  • Re: copying email body text to xl

    I have same question, please help me...

    I want to import my personal mails from my yahoo mailbox to excel sheet.
    I don’t want whole web page, I need only unread mail items.
    I am using office xp,internetexplorer, internetconnection through proxy server.