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

R

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 ([email protected]) 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
 
R

RCMetrics via AccessMonster.com

E-mails are coming from the same system, not clients... They are system
generated from an Extrenal system...

Now could you guide me in a few lines of VB:

What would "Have Access reach out to Outlook and grab the email" look like in
VB
What would "Have Access read the body text and parse out the values" look
like in VB

Load the value, I could figure out...
Have the user review ... this I could figure out too...

Mainly, I want to know how and what should be the VB code to initiate the
communication between Access and Outlook as well as how to pin point the e-
mails amongs other types of e-mails that we do not need to import.

Let me konw.

Thanks
Are the emails sent from Outlook clients or a variety of clients? Are
they from internal company departments or external companies? The
general process that I would recommend would be...

1. Have Access reach out to Outlook and grab the email
2. Have Access read the body text and parse out the values
3. Load the values into an Access form
4. Have the user review the data and then save the record (This will
ensure that any errors that occurred in parsing the data will be caught)
Wondering if the following can be done and if so what should the VB/Macro
look like...
[quoted text clipped - 26 lines]
 
R

RCMetrics via AccessMonster.com

Never Mind...

I think I have what I need...

Anyone looking into VB for importing e-mails into Access... Take a look at:

http://www.vb123.com/toolshed/03_docs/outlookorders.htm

Looks like its it...
E-mails are coming from the same system, not clients... They are system
generated from an Extrenal system...

Now could you guide me in a few lines of VB:

What would "Have Access reach out to Outlook and grab the email" look like in
VB
What would "Have Access read the body text and parse out the values" look
like in VB

Load the value, I could figure out...
Have the user review ... this I could figure out too...

Mainly, I want to know how and what should be the VB code to initiate the
communication between Access and Outlook as well as how to pin point the e-
mails amongs other types of e-mails that we do not need to import.

Let me konw.

Thanks
Are the emails sent from Outlook clients or a variety of clients? Are
they from internal company departments or external companies? The
[quoted text clipped - 11 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top