Trying to import Outlook 2003 e-mails content into Access...

[RCMetrics]

Wondering if the following can be done and if so what should the VB/Macro look like...

Background:

-hundreds of e-mails is sent to our department on a daily basis..
-E-mail are in a same format/size as they were generated from a system...
-This is currently manually copied from the e-mail body into a xls worksheet

Body is pretty much like:

Account: 9999999
First Name: John
Last Name: Doe
Service: What ever

...And so on... where anything after the ":" is changing according to the request sent to us... obviously all different.

E-mail size (1Kb), subject (some subject), Sender (Sender@sender.com) are always the same

Now, I'm looking into ways of avoiding this awful manual process and into getting a Raise...

Anyone can help?

I'd appreciate...

Thanks

 

[CT Witter]

Take a look at http://www.vb123.com/toolshed/03_docs/outlookorders.htm for a similar process.

HTH,
CT

 

[RCMetrics]

Looks like it's exaclty what I needed...

I'll post back once it's all setup and working

Thanks for your help.