VBA Script to monitor incoming mails?
Posted on 2013-11-28
Outlook + Exchange2007: Can someone tell me if this is possible please.....
I want to set up a Public Folder to contain mail for each of our customers. I want a copy of each incoming email to be stored in the Public Folder for that customer. I started to do this with Transport Rules on the Exchange Server, but we have hundreds of customers. So this would get really messy.
I'm competent in vba. I wondered if I could have a script which executed within Outlook. This would need to be triggered as each incoming mail arrived. My idea is that the script would query our sql server customer database, and if the 'From' address on the incoming email matches a customer email address in the database, then a copy of the email would be sent to that customer's public folder in Exchange.
Is this possible?