Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Automatically Turn on/off OOA based on day and time

Posted on 2009-04-23
5
Medium Priority
?
584 Views
Last Modified: 2012-05-06
We are running an Exchange 2007 environment on Windows 2003 Server and our workstations are running Outlook 2007 on Windows XP SP2. Both Exchange and Outlook are running the latest service packs. We have a call center environment in our company which answers emails during a specific period of time during the day from a single shared mailbox, from 8am to 6pm Monday through Friday. I know that you have the ability to configure your OOA to start at a specific date and time and also stop it at a specific date and time. I wanted to see if there was a way to automatically configure the Out of Office Assistance to turn itself on at the end of our shift and then automatically turn itself off at the beginning of the shift. Since it is a shared mailbox, what we have to do now to make that happen is log into that shared mailbox through Outlook and turn on the OOA at the end of our shift and then do the same when we have to turn off the OOA at the beginning of our shift. We would obviously prefer a free solution if there is one available. Our research so far has turned up some VB scripts but they have to run on the client side and for us since it's a shared mailbox, we just add it as an additional mailbox in our Outlook profile so we can see our personal mailbox along with the other shared one. THis solution would have to run on the server side or be something that we can enable without loging into this shared mailbox every time to configure the OOA.

Any suggestions would be greatly appreciated.
0
Comment
Question by:OWN3D
  • 3
  • 2
5 Comments
 
LVL 76

Expert Comment

by:David Lee
ID: 24224024
Hi, OWN3D.

I'm not sure this will work and am not in a position to test it.  You can try it and see what happens.  The worst that'll happen is it won't work.

1.  Open Notepad
2.  Copy the code and paste it into Notepad
3.  Edit the code per the comments I placed in it
4.  Save the file with a .vbs extension

Double-click the file to run it.  If it works, then we can talk about how to set it up to run automatically.

This code uses Collaboration Data Objects (CDO).  If they aren't installed on the server, and I don't know if Exchange 2007 comes with them, then this will not work.  CDO does not come with Outlook 2007, but might be on your computer if you upgraded from an earlier version of Outlook.  The computer you run this from must have a mail profile defined for the shared mailbox.  That profile name has to be entered on line 4 of the code per the comment.

Dim objMAPISession
Set objMAPISession = CreateObject("MAPI.Session")
'Replace Outlook with the name of your profile.  Replace Password with the password for that profile.'
objMAPISession.Logon "Outlook", "Password", False, True
objMAPISession.OutOfOffice = True
objMAPISession.Logoff
Set objMAPISession = Nothing

Open in new window

0
 

Author Comment

by:OWN3D
ID: 24225560
Thanks for the information BlueDevilFan. I ran the VB script on a WinXP workstation running Outlook 2007 with the shared mailbox profile setup and it failed with the error message "ActiveX component can't create object: 'Mapi.Session'. Code: 800A01AD. Source Microsoft VBScript runtime error. <<See attached: VBScript-Error-042409.png>. This was expected since it does not come with Outlook 2007 or XP natively. I then tried to install the CDO libraries following this MS article: http://support.microsoft.com/kb/171440/EN-US/%C2%A0 and got an installation error saying  "Collaboration Data Objects 1.2.1 cannot be installed with Microsoft Exchange." <<See attached: CDOInstall-Error-042409.png>.
Unfortunately I don't know where to date this possible solution from here. I also cannot make any changes in our exchange environment for this to work so any changes would have to be made on the client side.
Any help is appreciated.

VBScript-Error-042409.png
CDOInstall-Error-042409.png
0
 
LVL 76

Expert Comment

by:David Lee
ID: 24225924
I'm a little confused.  You tried the script on a workstation running XP and it failed because CDO wasn't installed.  You then "tried to install the CDO libraries" and got the error "Collaboration Data Objects 1.2.1 cannot be installed with Microsoft Exchange".  How did you get from trying the script in a workstation to attempting to install CDO on the Exchange server?  How about installing CDO on the workstation?  
0
 

Author Comment

by:OWN3D
ID: 24228344
I understand how that error message is misleading because it says it "cannot be installed with MS Exchange". I didn't try installing anything on the server. I will not be making any changes on our Exchange servers unless it's adding a server side rule of some kind.  I tried installing the CDO libraries on the XP workstation running Outlook 2007 and received that error message.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 1500 total points
ID: 24228576
Got it.  Don't know what else to suggest.  The code depends on CDO 1.21.  I can do it client-side in Outlook 2007, but you'd indicated that you aren't looking for a client-side solution.  The only other means I know of is to use a 3rd-party solution which isn't free.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Jet database engine errors can crop up out of nowhere to disrupt the working of the Exchange server. Decoding why a particular error occurs goes a long way in determining the right solution for it.
In my humble opinion (IMHO), TouchDown from Symantec is the best in class for this type of application, but Symantec has end-of-lifed it and although one can keep using it, it will no longer be supported or upgraded.  Time to look for alternatives t…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question