How to extract Outlook email information from a specific Inbox? 1

[freddiekg]

I have a need to use VFP to extract Outlook's email from a specific Inbox, e.g. "Archieve". Then, the extracted data will append into a DBF for storage purpose. Can this be done?

Appreciate your help.

 

[Mike Lewis]

The following code will give you a start. It will loop through the specified folder, displaying the contents of each message.

loOut = CreateObject("outlook.application")
lNameSpace = loOut.GetNameSpace("MAPI")
lInBox = lNameSpace.GetDefaultFolder(6)
lArchiveFolder = lInBox.Folders("Archive")

FOR EACH loM IN lArchiveFolder.Items
  ? loM.Subject
  ? loM.SenderName
  ? loM.Body
ENDFOR

I haven't tested this, but it should give you the general idea. You should be able to extend it to store the details in a DBF.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[JRB-Bldr]

To get a more general knowledge on automating Office components (including Outlook) through VFP you should probably consider getting the reference book.
Microsoft Office Automation with Visual FoxPro

http://www.hentzenwerke.com/catalog/autofox.htm

Good Luck,
JRB-Bldr

 

[freddiekg]

Dear Mike,

Thank you very much for your help.

I have a very important question that need your help:

I am in the process to write a VFP application that use DBC and DBF, and my challenge is the database has to store at the remote server that can access via IP address only at this point. I need your advice as what is the best way I can access the database without performance issues. Like using vfpoledb, ODBC, or using terminal service or etc. Please point me to the right places that I can learn more about this.

Thanks a lot!

 

[Mike Lewis]

Freddiekg,

I'm glad I was able to help with your Outlook problem.

Regarding your remote server problem, you've already started a separate thread for that (thread184-1573820). It's not a good idea to duplicate the question in this thread. If any answers were posted here, other forum members would not be able to find them, plus it leads to unnecessary duplication and thread drift.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[freddiekg]

Dear all,

I was able to extract the Outlook email information into a DBF from the Outlook "Archive" folder, and also able to reproduce the 'email' look alike output without the original formating attributes. It will be cool if I can reproduce the email just like the originals.

Is it possible to create a separate outlook .pst file just to store the archived emails and also put a link into the DBF so that the user can click the record and automatic bring out the outlook with the email display.

Any suggestions?

Thanks in advance.

 

[Mike Gagnon]

thread184-1574236

Avoid duplicate questions, please.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Yooooda]

I'm looking for something similar for Access. I need to be able to set the folder to a specific folder that is not the default. I have Access code that will open the default folder and code that will open a folder selected through the pickfolder routine, but I need to automate the system and have it automatically go to the correct Outlook folder from an Access database.
Any sugggestions would be helpful and appreciated.
Note: it is Office 2007.

 

[Mike Lewis]

In that case, it would be better to post your question in an Access-related forum.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business