Outlook --to--> Excel

Status
Not open for further replies.
T

thetechmind

Forerunner
Posting this here to save some time. Am searching for a software which has the capability to exporting the content of a mail to excel.

For example if I have a mail which has information from a data collection survey.

Example format as below.

Name :
Address :
Age :
Contact Number :

There are some 15-20 fields like this.

Now what happens is its a pain to copy paste the data from 'each' mail and paste it in excel in the required field / column. Is there a utility which would allow me to define the data and export it to excel.

I found a software which exports the 'entire' mail. But that is not something i'm looking out for currently.

If anyone knows of any such software with the exact / similar funtionality please let me know.

Can be freeware / shareware anything.

p.s. : I cannot modify the form to post data into a DB and then pull data directly into excel. There is a form that functions the same way, but this data collection form can't be modified.
 
Need to know what version of outlook and excel you are using. Depending upon that i will give you steps that you can try.

Usually all you have to do is you have to convert the excel file into a .CSV file and save it to the desktop.

Once that part is done, you need to open outlook and Open the import/export feature from File menu.
 
He wants to do it the other way round. Export as windows CSV file. But that wont work.

All the data will get populated in a single cell. So he cant segregate it into cells automatically
 
Ohh, sorry i got confused :ashamed:
Here try these steps which i got from MS office website:

# In Outlook, on the File menu, click Import and Export.
# Click Export to a file, and then click Next.
# Click Microsoft Excel, and then click Next.
# In the folder list, click the Contacts folder, and then click Next.
# Browse to the folder where you want to save the contacts as an Excel file (.xls).
# Type a name for the exported file, and then click OK.
# Click Next.
# To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields.
 
|Anish| said:
Ohh, sorry i got confused :ashamed:
Here try these steps which i got from MS office website:

# In Outlook, on the File menu, click Import and Export.
# Click Export to a file, and then click Next.
# Click Microsoft Excel, and then click Next.
# In the folder list, click the Contacts folder, and then click Next.
# Browse to the folder where you want to save the contacts as an Excel file (.xls).
# Type a name for the exported file, and then click OK.
# Click Next.
# To add or remove fields to determine the way the contact information is saved in the new Excel worksheet, click Map Custom Fields.
Click to expand...

Anish, :no:

This is exactly of what im not looking for ......and Renegade answered above why! :( ....it works for sure , but i do not wish to have the entire content of the body passed along....it should search the data in the body and place it accordingly in the needed place.

I found a tool which converts the mail to a db and from db excel can read and import.....freaking 295$ :no: ......still looking out for some free solution or some custom code...
 
Can you send me a sample mail? I will try some python tricks on it.

Let me know.

~LT
thetechmind said:
Posting this here to save some time. Am searching for a software which has the capability to exporting the content of a mail to excel.

For example if I have a mail which has information from a data collection survey.

Example format as below.

Name :
Address :
Age :
Contact Number :

There are some 15-20 fields like this.

Now what happens is its a pain to copy paste the data from 'each' mail and paste it in excel in the required field / column. Is there a utility which would allow me to define the data and export it to excel.

I found a software which exports the 'entire' mail. But that is not something i'm looking out for currently.

If anyone knows of any such software with the exact / similar funtionality please let me know.

Can be freeware / shareware anything.

p.s. : I cannot modify the form to post data into a DB and then pull data directly into excel. There is a form that functions the same way, but this data collection form can't be modified.
Click to expand...
 
linuxtechie said:
Can you send me a sample mail? I will try some python tricks on it.

Let me know.

~LT
Click to expand...

I wont be able to forward an actual data...but i'm quoting as it comes in the mail......

some data para here.......

some data para here.......

some data para here.......



Name: ABC

Company: ABC

City:

Country:

Email:

Phone:

Website:

How did you find us:

Comments:

some data para here.......

some data para here.......
Click to expand...

so all i need in excel is the data u see above in red.

Opening each mail and copypasting the stuff into excel and then revalidating is a painfull job.....and if i can manage to automate this this will save a 'lot' of time considering the number of mails that come in time saving per day would run into hours.
 
thetechmind said:
I wont be able to forward an actual data...but i'm quoting as it comes in the mail......

so all i need in excel is the data u see above in red.

Opening each mail and copypasting the stuff into excel and then revalidating is a painfull job.....and if i can manage to automate this this will save a 'lot' of time considering the number of mails that come in time saving per day would run into hours.
Click to expand...

Hmm , say is this going to be a GMAIL (POP) mail or going to come from M$ Exchange?

If its POP, then I can do following:

o. Read mail from the pop account (with username and password).
o. Filter the mail for those key words mentioned.
o. Create a CSV row and add in a csv file.

This csv can be opened in Excel anytime.
Wont take too much time.

~LT
 
linuxtechie said:
Hmm , say is this going to be a GMAIL (POP) mail or going to come from M$ Exchange?

If its POP, then I can do following:

o. Read mail from the pop account (with username and password).
o. Filter the mail for those key words mentioned.
o. Create a CSV row and add in a csv file.

This csv can be opened in Excel anytime.
Wont take too much time.

~LT
Click to expand...

Excellent man !.......would be wonders....
this mail will come in via POP!.......directly into my MS Outlook...
from the web it goes directly to a account and from that account it comes to be as a redirect.......
 
thetechmind said:
Excellent man !.......would be wonders....
this mail will come in via POP!.......directly into my MS Outlook...
from the web it goes directly to a account and from that account it comes to be as a redirect.......
Click to expand...

Ok, give me couple of days... seems fair? Ohh btw I assume you are ok with installing Active Python. :ohyeah:

~LT
 
linuxtechie said:
Ok, give me couple of days... seems fair? Ohh btw I assume you are ok with installing Active Python. :ohyeah:

~LT
Click to expand...

i dont mind installing anything provided u guide me how to go about it.....:bleh:
also this would be used widely across.....the only issue would be if there is some modifications that need to be done or 'support' related issue arises then LT would have to be buzzed.....

p.s. i figured out its something to do with parsing of data and stuff....my bad i cant code that hardcore...
 
thetechmind said:
i dont mind installing anything provided u guide me how to go about it.....:bleh:

also this would be used widely across.....the only issue would be if there is some modifications that need to be done or 'support' related issue arises then LT would have to be buzzed.....

p.s. i figured out its something to do with parsing of data and stuff....my bad i cant code that hardcore...
Click to expand...

Dont worry re, python is really easy and the piece where its going to happen will be very easy, so you can fix stuff yourself. Will post soon.

I myself infact believe in fixing stuff in python if it doesnt need that C++/C stuff.

~LT
 
linuxtechie said:
Dont worry re, python is really easy and the piece where its going to happen will be very easy, so you can fix stuff yourself. Will post soon.

I myself infact believe in fixing stuff in python if it doesnt need that C++/C stuff.

~LT
Click to expand...

ty in advance.
 
thetechmind said:
Excellent man !.......would be wonders....
this mail will come in via POP!.......directly into my MS Outlook...
from the web it goes directly to a account and from that account it comes to be as a redirect.......
Click to expand...

It would seem to me much better if you have the ability to capture that data at the webserver itself. I assume this is some kind of a online form that is being filled up. Instead of creating a email, can you direct the form data to say a MySQL database?
That would be a simple and direct approach.
 
Emil said:
It would seem to me much better if you have the ability to capture that data at the webserver itself. I assume this is some kind of a online form that is being filled up. Instead of creating a email, can you direct the form data to say a MySQL database?

That would be a simple and direct approach.
Click to expand...

Thanks, but :O did you happen to read the P.S. section in my main post :)

p.s. : I cannot modify the form to post data into a DB and then pull data directly into excel. There is a form that functions the same way, but this data collection form can't be modified.
Click to expand...

This form is at a remote location not managed by me or my organization or I cannot modify / have the form modified. It stays as is.
 
thetechmind said:
Thanks, but :O did you happen to read the P.S. section in my main post :)
Click to expand...

Sorry. I had read it when I had first read this thread.
When I answered, it was the next day, by which time I addressed a later post without going back and checking the original thread starter post.
 
linuxtechie said:
Ok, am done. Testing time, send me your email id and I will post you the stuff.

~LT
Click to expand...

dammm missed out on this thread completely....sending you a PM......and mails come in usual txt or html format.........

pm'ing you my official mail id....
 
Status
Not open for further replies.
Top Bottom