Maschinensucher new

hi, we get a list of inquiries via email each day. The email is standardized and includes adress, name, company, a machine category and more. The emails are saved on the drive in txt file format. Now I would like to have a VBA script in Excel or open office calc, that is able to go in the specific folder and open the latest email/txt file and put the data (adress, name etc.) in a Excel spread sheet, save it as csv file so we can further upload it into Outlook and mailing software each day. The first line contains: company, name, street, place, machine category ...so actually the title of the fields. The following lines include the specific content that has been filled out by customer. Here is an example (the item on front of the ':' is field name and after the content entered by customer, adress is in the second line): Firma: Gampper Armaturen GmbH, Name: Julian Gampper Niedermoscheler Str.2 67821 Alsenz Tel: 06362 3020, Fax: 06362 30226, eMail: Kategorie: Werkzeugmaschinen,Metallbearbeitungsmaschinen, Drehmaschinen , CNC Dreh-Fraeszentren Kontaktwunsch: per eMail Status: Maschinennutzer Anfrage an Sie: Suche 'CNC Drehmaschine INDEX ABC' oder aehnlich Tricky here: the adress contains street and no. As well as zip code and place. This should be separated. Also field left blank by customer dont appear, eg Firma: is blank, then it doesnt appear. Alternatively the email can also been processed directly from Outlook and saved as csv file Tomorrow i will attach the email and draft excel file to show more.