×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

can I fetch and process outlook email msg

can I fetch and process outlook email msg

can I fetch and process outlook email msg

(OP)
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

 

RE: can I fetch and process outlook email msg

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
www.studiosoft.co.uk

RE: can I fetch and process outlook email msg

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close