Pubmed email extractor

Project Description:
Hi, I need the same, including the abstract and every data set, with and without e-mails. Best would be to have all available fields of the xml file as a openoffice base file or as a csv file for importing.
------------------------------------------------------------------------------------------------------
Text of the other old project:
I am sure that this tool already exists, but I could not find it.
I need is a tool, which would take the XML dump (see attached two files) and extract the following fields into Excel Spreadsheet:

First Author First Name (first author in the author list)
First Author Last Name
Affiliation
Email Address
Journal Name (e.g. Nature) (in XML dump it usually goes as Title)
Article name

The program should check if the last name of the first author is present in the email address. If not, first and last name of the Last Author (last author in the author list) on the publication should be used.

The program must tolerate files with twenty thousand records.

Only about 20% of entries have emails.