Re: Import and Insert data from email

Hi,

Not an email form but maybe a format like below where the end user just
types line after line, need to read this when it comes in and insert into
table the email itself would be sent to booking@xxxxxxxxxxxxxxxxxxxxxxxxx
for example.



0102

001/00236

13/02/2008 15:00

STANDARD VEHICLE

MR JONES

20, HA1 3RT

333, W10 6RA









Explanation of above for your reference

Account number

Booking reference

Date time

Vehicle type

Passenger name

Collection address

Destination address

Thanks in advance

Regards

Simon

"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:j9adnd5EtvuerS7anZ2dnUVZ_vShnZ2d@xxxxxxxxxxxxxx
"Simon Gare" <simon@xxxxxxxxxxxxx> wrote in message
news:e49HuMmbIHA.5888@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

have a client who receives email bookings, need to read the email (maybe
in
asp page) and insert it into db.

Any ideas.

A few more details would be helpful.

What would be stored in the database; perhaps just:
Date Sent
From Name (if available)
From Email
To Name (if available)
To Email
Subject Line
Message Body

Are the messages in plain text or HTML?

Would there be any attachments? If so, what type?

What would the client effort be; would they be willing
to cut-and-paste a "Reply To" copy of the email into
a textarea?

Once in the database how would they be used?




.