PDA

View Full Version : VBA with MAPI for Outlook Express



LabNS
07-29-2009, 07:28 AM
Hy everyone,

I am searching a way to develop a VBA for Access 2000 where (probably with MAPI) I will be able to retrive/read e-mail from my Outlook Express folders.
I have found a lot of stuff for MS Outlook or for other languages, except VBA with Outlook Express.
(I'm not instereted in Sending mails, just Reading from folders)

I would be gratefull If someone had something to share (a sample code or any idea how to do it)

VBA - Access 2000 - Outlook Express (NOT MS Outlook).

Thank you for any help

LabNS
08-11-2009, 01:03 AM
No answer, hard question probably or not possible request.

Any way, I hope for an answer sometime soon :hi:

OBP
08-11-2009, 04:21 AM
This sends emails, so may be able to be modified to read them.
http://www.freevbcode.com/ShowCode.asp?ID=5213
Try this one as well
http://www.bigresource.com/VB-list-the-outlook-express-folders-in-vba-jfYuihqqf9.html

kbsudhir
08-12-2009, 03:46 PM
By reading do you mean opening the mails or copying the mail attributes i.e mail body etc to some other application i.e excel or access.

I have a code which updates the access tables with mail attributes, another which opens the attchments.

Please let me know what exactly you are looking for & I may be having codes to help you out.

Regards
Sudhir

kbsudhir
08-12-2009, 04:04 PM
You can also checkout the below links

http://www.outlookcode.com/messages.aspx

Also you can check out my thread (Link provided below), in this thread I am trying to open & reading the attachment.

http://www.vbaexpress.com/forum/showthread.php?t=24194

This one will help to forward the mail to list of adresses:

http://www.vbaexpress.com/forum/showthread.php?t=22755

If you are planning to run the macros from another application then make sure that you add the refernce for "Microsoft outlook object library". the version of this library will change as per the office version you are using.

For office 2007 the library is "Microsoft outlook 12.0 object library".

The above links will give you better idea on Outlook objects. I have done these on MS outlook 2003. You can just check them out for your outlook express

Regards
Sudhir

stanl
08-13-2009, 02:35 AM
Outlook Express is not programmable AFAIK. It has been deprecated in Windows 7 in favor of Live Mail.

LabNS
08-25-2009, 02:51 AM
Thanx everyone for the replies.

I could not be more specific about this.

kbsudhir: Thanx for the links but the links and codes are all for Outlook, not OE.

OBP: The second link gives no answer to the question (not mine).
The first one is something I mention I found, but it is not programmable to read mails. Thanx though.

stanl: Everyone who has basic knowleg, knows that OE is not progammable. I am not trying to make something crazy here. Only to check if there was a MAPI turnaround to read an OE folder/mail.
I dont want to be rude but if you dont have an answer, then dont post.
(few years ago DBX was not readable, and today it is almost by anyone)


It seems that there is nothing out there that could do the trick. I have developed an API that opens (binary) the OE dbx files and reads e-mails, but BDX files are in no way synchronized with OE and also the binary reading has a lot of flows to use it (like duplicates of deleted messages etc).
Anyway, since I have been searching for a long period, I think that the best way is to migrate to Office Outlook where you can use VBA inprog also.