Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can I fetch and process outlook email msg

Status
Not open for further replies.

dainova

Programmer
Jul 2, 2002
14
US
Hi,
I'm trying to help one nonprofit to get their visit orders into xls, those orders come as email (outlook for now), inside there is pasted fragment of xls (it pasted and unfortunately sender can't send the whole xls or part of it as attachment because of some private concerns).
So I'm thinking to find those .pst files and parse them extracting those lines (they have some unique "RRR" string at the beginning), then putting header file and open/save this as xls or csv. Actually i need to append those messages into one file as there are 10+ of them daily.
Onother way is probably to dump all inbox folder into .txt messages and then do save it as xls?
Can anybody tell if its make any sense? I know that Perl has some modules actually to create xls inside too, is it right?

Appreciate you ideas and critic very much.

Tx
Dai

 
Not sure what you mean by get visit orders into xls but I would suggest you step back from the current plan and look at the whole problem. It is very easy to get bogged down, heading down a particular road.
You say, 'Outlook for now', why not set it up do do what you want now, before you get in any deeper.
Perl can do exactly what you want, you just need to decide what you want.



Keith
 
Thanks, Keith

Yes, now i know what I need to do, I need to fetch outlook msg content and put it into xls. There is a logic to follow inside this messages, which I can easy implement in perl.
So for now I have question how to refer to this ".pst" outlook messages?

Thanks
Dai
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top