transfer text in outlook to database

antonyx

Arsenal Supporter
Local time
Today, 11:14
Joined
Jan 7, 2005
Messages
556
if i receive an email consisting of the following:

Name: Antony
Phone: 887
Country: UK

can there be a way to transfer these details from outlook into an access table with 3 identical fields?
 
can it be as simple as copy the text into notepad (CSV) or excel and then import them to access?
 
yes it could be that simple but then i would still have to manually copy each item and paste it into the correct cell then synchronize the csv file with the database...

at the moment my customer fills out a website form
the results are emailed to my outlook account
then i manually enter the outlook details into my database form..

now i realise that i could tell the website form to input the details str8 into a database and sync the 2 databases.. or if my security was good enough (which is isnt due to financial restrictions) i could have my main database online and feed the website form str8 into that.. but that is not what i want to do at the moment

i may email my customer 2 or 3 times before their details are ready to be placed in the system.. so what i would prefer is some kind of system that allows me to auto-input into the database the details shown in the email i am looking at..

anyone done this kind of thing before?
 
Is that an attached txt file or just text in the e-mail? I transfer attachments in to my database from outlook with a couple macros in outlook.
 
it is actual text in the email not an attachment..
 

Users who are viewing this thread

Back
Top Bottom