can I fetch and process outlook email msg

[dainova]

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

 

[audiopro]

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

http://www.studiosoft.co.uk

 

[dainova]

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

 

[rharsh]

This may help: Perlmonks - Manipulating MS Outlook PST files