mscertified,
The short answer to your question is that it should be very possible.
I went back and took a look at an application that I wrote a few years ago
to do something very simular to what you are describing.
The situation that I wrote the application for was that we had more than one
entity sending emails with attachments in the form of csv files. A special
Inbox was created to receive these emails. Then when my application opened,
it checked to see if there were any new emails. If new emails were found in
the InBox, the existance of attachments was also verified and the user was
notified of the existance of the new emails.
At the users discression, the new emails with their attachments were
processed. This process included: check each email to deteremine the number
of attachments it contained, save each attachment to a predetermined folder
with perdefined file names (naming for each entity sending the email, based
on the sending email address). Once all of the attachments were saved, each
attachment (a csv type file) was imported into the database.
Although we did not just place information from the body of the email into
our database, I know that if the body of the email contains text that is
always in the same format (comma or other character delimeted) you could very
easily parse out the individual data pieces.
I hope this is helpful to you. As you have other questions, please just
post back and I feel sure that me or someone else will be glad to help
