On Mon, 16 Apr 2012 22:52:01 +0100, Chris Bode wrote in
microsoft.public.outlook.program_vba:
>I have a need to execute some SQL Stored Procedures based on the
>contents of email messages being delivered to a shared mailbox. I've
>written code and attached it to "ThisOutlookSession" and it works like a
>charm. The issue I'm running into is in creating a rule to run this code
>when messages from a specific recipient are delivered to this shared
>mailbox. I've created an Outlook profile with only this mailbox and
>created a rule, but it doesn't fire when I try to run it on the messages
>in the inbox, which definitely meet the rule's criteria.
>
>Is there maybe a better way to go about this? Ideally, a server-based
>solution not requiring Outlook to be running would be fantastic. If a
>server-based rule could save those messages to a watched network folder,
>and spawn some other process to perform the SQL updates, that'd work,
>too, but I don't think that's possible.
>
>Any pointers would be most appreciated...
A shared mailbox is just like any other mailbox, only many people can
access it, right? Well, that's how our shared mailboxes are set up.
I don't quite follow your description about what's working and what's
not working under what circumstances. If code fires and runs when it is
part of your ThisOutlookSession but doesn't run when the shared mailbox
is logged in and has the code attached to its ThisOutlookSession, then
the conditions to fire the code are not being met, or something really
weird is going on. You also forgot to mention which version of Outlook
and Exchange you are dealing with.
Have you researched Exchange server-side scripting? Exchange Web
Services (EWS)? CDO message sinks?
--
Michael Bednarek, Brisbane "ONWARD"
|
Similar Threads
