Outlook 2007 Automated Response on Assignment/Resolution

[SuperFerret]

This is a long shot, but I've been tasked with attempting to find a way to send a response to e-mails we get in. Basically we have a Group Inbox, which our team has access to, when we are dealing with an e-mail we flag it with a Category so everyone else can see it's been done. The problem is we get a lot of e-mails and people are now wanting a 'Done' email.

Is there a way to either send a response once a Category has been assigned to an email (something like [username] is dealing with this) or ideally when the e-mail is moved into a specific Work Completed subfolder (we have one for each team member of which there are currently 3 of us)

Any help/advice is appreciated as I've googled this, but I'm not sure what I should be searching for.

 

[JP2112]

This is a long shot, but I've been tasked with attempting to find a way to send a response to e-mails we get in.

LOL just hit "Reply"?

I haven't tried this, but you should be able to add an event handler to that Inbox and, when any item is changed, determine what the change is and create a response email automatically.

See http://www.codeforexcelandoutlook.com/outlook-vba/mailitem-object/events/ for sample code. You should be looking for the PropertyChange Event to see how to do it.

The code would need to be installed on every machine that is used to access the Group Inbox.

For moved emails, you would need completely different code. See http://www.codeforexcelandoutlook.com/outlook-vba/stock-event-code/ for "watch-folder" type of email handling.

 

[SuperFerret]

LOL just hit "Reply"?

Lol! This is what we're doing already, but the number of e-mails has now got to a point where we're spending more time responding than doing our jobs!

I'll check out the links and see what I can put together, they've not decided what they'd rather have (moved or flagged) yet so if I can give examples of both we can see what's gonna work best.

Thanks for the response!