Re: Import and Insert data from email

"Simon Gare" <simon@xxxxxxxxxxxxx> wrote in message
news:ecBRIDnbIHA.4936@xxxxxxxxxxxxxxxxxxxxxxx
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


Please do not top post as it makes the conversation harder to follow.


"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?

You did not answer all of my questions.

Regarding your response:

Can a consist format always be guaranteed?
If so then perhaps it can be parsed out accurately.

Would you send me an example of a real email;
(though of course you could change some of the data)?

Since you mentioned it, is or could an Web form be
used to generate the email? If that form is under your
design control it could propagate the database on submit,


.

Relevant Pages

  • Re: Import and Insert data from email
    ... STANDARD VEHICLE ... Booking reference ... What would be stored in the database; ... What would the client effort be; ...
    (microsoft.public.scripting.vbscript)
  • Re: Protel 2004 answer to Brad Velander.
    ... Sorry, you misunderstand me, I mean to say that jump from 99SE to 2004 XP ... you don't have the same format with one database will all the documents. ... Well you said that you can export file format more recent than AUTOCAD 14 ... key/mouse click you press because I don't know how to do that with Protel ...
    (sci.electronics.cad)
  • Re: Combo box not finding record... sometimes
    ... Try the Format option last. ... Private Sub cboLnNum_AfterUpdate ... when I change the data type from Double to Long Integer the database ...
    (microsoft.public.access.formscoding)
  • Re: Error Message: Cant find Installable ISAM
    ... The database is residing on my machine, ... Error Message = "Couldn't find Installable ISAM" ... Connect property set = Access ... Access 2002/2003 format and tried this as a possibility, ...
    (microsoft.public.vb.database)
  • Re: What program is best for large inventory?
    ... put the information in the format that I want. ... down into several sub groups and some even further. ... The learning curve for general database concepts is moderate. ...
    (microsoft.public.office.misc)