First of all, sorry for my bad english, I'm from Barcelona (Spain) and I took FCE many years ago.

I need help with one problem. At work, everyday, I receive more or less 100 emails with customers data, they are written following a template. The data appears in the mail body. Now, I have to fill this data in an excel file manually, I'm looking for a way to do it automatically.

I want to know two things. One, if there is any way to run a macro everytime a new mail arrives at the inbox. The second is a bit more difficult, I need to know how to export only the costumer data to a csv file.

For example, I receive something like this:

Name: Example
Telephone: 555555555
Asks for: 3000?

And I want to save a csv like "Example, 555555555, 3000?"

I've been reading this forum and others and I've tried to modify some codes but they don't work. I don't know how to refer to the body mail and to save to csv.

I wil be very grateful If anyone can help me.

Regards.

Khan.