Isecretl, sorry about the late reply. If you replace 'important' with 'inbox' then this code shoudl work.
As for stopping it replicating the messages, the best way to do this would be to create a record set in VB and hard code the query aswell, that way you could check if the table already contains another similar email.
If you need help writing this code then just let me know
dont worry about it i appreciate your kind assistance. due to the nature of this scope as it needs to run preferrably hourly 24 / 7 (Meaning run the query)
i actually tried to set a rule in outlook to forward the incoming mails into a seperate folder. Once there, there is a linked table from ACCESS to that particular folder. I then schduled a ms task to run a asp to query and extract accordingly.
Here is a little dilemma, when i query from MS access itself the query works fine, but when i put the query into asp i get this
"There are no MAPI clients installed on this machine. Install a MAPI client (like Outlook) on this machine"
*outlook is installed on my notebook as well as the server hosting the IIS*
The moment i change the query to query another normal table in access the asp works fine...
i am really unsure if i am going in the right course but when i tried to search on the net for this error for 3 days now, no progress i am really depressed lol