I receive around 300 mails daily with the following line in the message body

S1ACXXXXXXX | ABCDEFGHIJKLMN | FATAL ERROR CLOSED | Down for Time: 1:10:24

While the first field is always fixed with 11 letters other fields length vary. Can anyone suggest how to automate this to update / write in a database with four text fields. The email is always received from the same user (sender is same for example xxxx@mysite.com). I have tried the facility available in Access 2007 but there we need to send a form and in the reply in HTML format the reply is sent and the same is processed. But in my case the mail is in simple text format.

Thanks in advance to all the experts. As this is my first post kindly guide me if already a solution exists for this. I have searched the forum before posting this but I might have missed it as the search words given by me might not have matched with any posts.