Monitor Inbox For New Email

[trevorwilliams2]

I looking for a way to have Access monitor an Outlook inbox for newly received mail and store the various properties of that email to a table.

I have been able to accomplish storing this data, by manually specifying the selected email in the inbox using the Outlook.MailItem object to gather everything.
This works great, but I would prefer to have this automated. Timer event maybe?

How can Access determine if the mail item is new?

Any input would be greatly appreciated!

Access / Outlook 2003

 

[Blorf]

Hi. I had a similar requirement. I solved it by creating a rule in outlook on new mail arriving. I wrote my code there to post the information into a SQL Server table, rather than have access running to do the work.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[trevorwilliams2]

I found a way around it simply by checking the date received in my db against the date received of the email.

If incoming received date > the last stored email in the db then bring it in...

This worked great until I tested it on a large inbox.
The code is looping through the whole inbox to compare dates and this takes forever.

I am now trying to find a way to filter the search of the inbox down to the last years worth of emails.