Processing Outlook eMails with VFP

[DChalom]

There may be a poat on this already. If there is please point me the way.

I started this project thinking i would just process the eMails in FoxPro and delete them when I am done. But I was thinking this morning that the customer may want to save those emails in Outllok as well. So here is the whole procedure I need:

eMail comes into this certain account

Read the last name of the person, which is in the body of the eMail

The eMail may have links in it.
Open the links
Save the documents to a folder
the folder name made up of the last name and a
case number
the case number is on the subject line

Depending on the first letter of the last name
crate an email to go to a certain person.
With the last name and case number in the subject
line
Attaching the documents that you down loaded

Then save the eMail to a Folder in Outlook made up of the Clients last name and case number.

It is this last step that made me think I need to go about this through Outlook rather then just reading the eMail from the server.

Please I hope some one can point me in the direction.

Dorian C. Chalom

 

[Mike Gagnon]

Dorian

FAQ184-3894 might get you started. Although it does not show you step by step the code that meets your requirements (This is not the purpose of this forum), but it should help.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

Mike,

Thank you. Yes I realize the Forum is a place for me to get help, not get my work done. I just needed a direction to go in and you helped with that.

Thanks again,

Dorian C. Chalom

 

[DChalom]

My only question now is how do I test this application once i develop it? Do I need another system to test it on? Or may I test it on my current system setting up another Outlook account to pull the emails off of?

Dorian C. Chalom

 

[Mike Gagnon]

Dorian

Have you tested it on your own system? Can you get results on it?
If you loop through your own received e-mails can you filter on one specific message and download the attachment?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

But my question is these emails I will be processing are formated in a very specific way and the processing on them I need to do requires me to read in the email and process certain information in from it including HTTP links to documents that I need to open and store to a certain location on the hard drive. The reason I want to do it through Outlook and not right off the email server is that these emails need to be saved and stored into certain folders in Outlook.

Dorian C. Chalom

 

[Mike Gagnon]

Dorian

Ok, let us start from the beginning. How far did you get?
1. Are able to automate Outlook?
2. Can you get to the inbox? (I assume this is where the messages are.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

Im not that far yet. I am just in the thinking stages right now....

Dorian C. Chalom

 

[Mike Gagnon]

Dorian

Im not that far yet. I am just in the thinking stages right now....

Ok, so at the moment you are not having any specific problem?

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

I guess you could say so.

I guess I will wait until i get stuck then.

I would like to be able to have all the answers before I dive in though.



Dorian C. Chalom

 

[Mike Gagnon]

Dorian

I don't thing there is much of an issue. The only thing that may be of concern might be this "HTTP links to documents that I need to open and store to a certain location on the hard drive."
Other than that, in don't see a problem.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

Then my question is...do you have any direction on where I can convert an "URL to a File"?

Dorian C. Chalom

 

[Mike Gagnon]

Didn't you already answer this question in thread1251-849030?

In order to get a file from an HTTP server, you need to imitate what a web browser does. Create a connection, set the parameters, issue a request and the data will be streaming to you from the webserver.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DChalom]

Yes we did already cover this thank you.

I will let you know how the progress proceeds.

Thanks for your direction

Dorian C. Chalom