Re: Import and Insert data from email

Ok here are the answers

I will assume plain text, could we read either plain or HTML from different
clients?
No attachments
No cut and paste
Once in db journey is passed to mobile device for driver journey details
Consistent formula can be guaranteed
Web form not an option
Yes the online form validates the address using Royal Mail paf file then
calculates the distance using MapPoint

All this because of 1 client who insists in sending email instead of filling
our form.

Also can you clarify "Also, I asked for you to send me an email not post
it."

Regards
Simon







"McKirahan" <News@xxxxxxxxxxxxx> wrote in message
news:uPqdnZqEyIdQzi7anZ2dnUVZ_qOknZ2d@xxxxxxxxxxxxxx
"Simon Gare" <simon@xxxxxxxxxxxxx> wrote in message
news:O6I3hznbIHA.5348@xxxxxxxxxxxxxxxxxxxxxxx
Well this is the question, but if we had a strict policy inplace and
description as to what format to lay it out in could we read from the
email
body line by line in an asp page where we could validate the address and
insert into db?

The format I sent you before is a real email.

Please quote what you are replying to so others can follow the
conversation.

Validate what address -- Email, Collection, and /or Destination?


You still haven't answered each of my questions. Here they are again:

Q. Are the messages in plain text or HTML?
A. I presume "plain text"

Q. Would there be any attachments? If so, what type?
A. I presume "no attachements".

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

Q. Once in the database how would they be used?

Q. Can a consistent format always be guaranteed?

Q. Would you send me an example of a real email?

Q. Could an Web form be used to generate the email?

Q. How would you handle missing data?

Q. Does the "online booking interface" insert records into a db?

Also, I asked for you to send me an email not post it.
Why, becuase they're different!




.

Relevant Pages

  • Re: Outlook not sending attachments
    ... tested my setup using Plain Text and the attachments went ... >>I use Outlook 2000 as my email client. ...
    (microsoft.public.outlook.general)
  • Re: Is VMS losing the Financial Sector, also?
    ... Not sure what is wrong with your client or my client, ... The Outback 2007 client I use says Internet plain text format. ... It says something like "plain text", to the user using the Microsoft ... Sad, sad, sad, sad, sad. ...
    (comp.os.vms)
  • Characters in plain text messages getting converted to HTML code in display
    ... I have a client who can't view plain text messages properly in Outlook ... This didn't fix it for me. ... forward to the prospect of creating a new user account and spending ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Is Plain Text email 100% safe?
    ... There can be no virus in the body of a plain text email, but the attachments might still be infected, if they're in some format other than plain text. ... They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. ...
    (microsoft.public.security.virus)
  • Re: Preview pane is blank
    ... "Robert Aldwinckle" wrote: ... when she called to say she couldn't open her attachments. ... Now imagine that there is no Plain Text component to that E-mail... ... and just open the E-mail in its own message window? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
Loading