General information
Category:
Third party products
Environment versions
Network:
Windows 2000 Server
Dragan,
I hate to mention this because I might get thrown off the forum, but... This is pretty easy to do with Access. There is a built-in linking mechanism in Access that will let you create a linked table directly to any Exchange mailbox or contact list, etc.
Bill
>This is about Fedex tracking - they are sending automated emails whenever a shipment is sent (i.e. scanned on departure) or delivered. I want to write an application which will just read these emails, extract data from messages (which are, luckily, plain text) and store them in a DBF.
>I've tried several approaches:
>
>- Outlook - no way, too much security hassle, this needs to work unattended
>- CDO - this again hooks into Outlook somehow, or presents a dialog
>- MAPI - turns out to be another way to invoke some Outlook object, dialog again
>- webmail via an IE object, parsing the HTML - this is the most promising so far, but it detects inactivity (!) and requires a login after each few pages. The login can be automated, though, and maybe in the end that's what I may end up doing, if more elegant approaches fail.
>- ADSI - the documentation is so labyrinthine, whatever I look for gives me a new way to look for printers, users and their rights.
>
>So, is there a way to do some sort of SQL-like select from Exchange server's messages, for a given user and time interval? If so, what would be the format of the recordset? ADO RS, I presume, or XML?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only