OutlookEX UDF
#21
Posted 28 April 2011 - 03:27 PM



#22
Posted 28 April 2011 - 03:28 PM
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#23
Posted 04 May 2011 - 04:31 PM
I am currently using a conglomeration of OutlookEX and the Outlook UDFs.
I do find this UDF useful, even to the extent of possibly assisting to improve it / add features.
Admittedly, right now, I'm using it as a glorified Rules script, but it is still helpful.
Thanks again,
Carson
Edited by JCarson, 04 May 2011 - 04:33 PM.
#24
Posted 05 May 2011 - 10:03 PM
Glad you like the new UDF :-) What do you think is missing right now? What should be added?I do find this UDF useful, even to the extent of possibly assisting to improve it / add features.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#25
Posted 18 May 2011 - 02:05 PM
Please test before using in production!
For download please see my signature.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#26
Posted 23 May 2011 - 01:03 PM
I would like to know
- is the UDF useful for you?
- do you use it in production?
- do you miss any functions?
BTW: If you like to tell me how satisfied you are with the UDF please go to the top of any page, section "rate topic", move your mouse to the corresponding star in the upper right corner and click to rate.
Edited by water, 23 May 2011 - 01:04 PM.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#27
Posted 16 June 2011 - 08:39 AM
What do you think about the "Out of Office" message? Would anyone like to see functions to access/manipulate this?
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#28
Posted 17 June 2011 - 09:29 AM
I would like to see functions to manipulate OOO messages!
Maybe they would work much better than mine... (Currently I'm using AU3 + PowerShell.)
What I'm looking for:
- Switch OOO message on/off.
- Change OOO message text.
- Manipulate OOO messages for/of other users.
- List which users currently have their OOO on (incl. mail redirection).
I know, it's only a wish list...
Greets,
-supersonic.
Edited by supersonic, 17 June 2011 - 09:30 AM.
#29
Posted 22 June 2011 - 09:08 AM
I'm going to put it on my ToDo list.
Some more investigation is needed because I've got the impression that it isn't possible to query OOO using the COM interface (but I'm not 100% sure).
And before I spend more time I wanted to be sure that the functions are needed at all.
Could you please post what you have so far? Maybe it points me into the right direction ...
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#30
Posted 23 June 2011 - 01:13 PM
Please test before using in production!
For download please see my signature.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#31
Posted 23 June 2011 - 03:09 PM
Hi supersonic,What I'm looking for:
I know, it's only a wish list...
- Switch OOO message on/off
- Change OOO message text
- Manipulate OOO messages for/of other users
- List which users currently have their OOO on (incl. mail redirection)
here is what I have so far (Edit: please check post #41). This should solve issues 1 and 2. Could you please test the function and report the results?
The example code sets the text and activates the OOO reply.
The OOO message is simply a hidden message in the Inbox of a user. If you have write access to the mailbox of a user it should be easy to change the function accordingly and solve issue 3 (Edit: I now have a version that allows to change the OOO of another user).
Issue 4 is a bit more complex. At the moment I don't know how to list those users. This information is stored on the exchange server and therefore should be queried by accessing the exchange server (or active directory if possible). Because you want to get this information even if the user has powered off his PC and went on vacation, right?
Edited by water, 29 June 2011 - 12:35 PM.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#32
Posted 26 June 2011 - 05:28 PM
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#33
Posted 27 June 2011 - 07:36 AM
sorry for replying so late...
Thank you for your work; the new function works pretty well.
The only thing is that I get the following error:
WARNING: $olPrimaryExchangeMailbox: possibly used before declaration.
(For the test I removed the If-condition...)
Can you give me a clue how to change the OOO for an other user (issue 3), please?
I have an user account which has access to all others' mail boxes... Is there a special syntax?
You asked what I have so far...
Due to the fact that my script is very ugly and it reverts to PowerShell it will not be helpful.
But I can give you the www-sources:
http://gsexdev.blogspot.com/2007/03/combined-summary-and-audit-vbs-script.html
http://gsexdev.blogspot.com/2008/02/class-library-to-help-setting-out-of.html
http://gsexdev.blogspot.com/2009/08/setting-out-of-office-oof-with.html
http://gsexdev.blogspot.com/2009/11/basic-powershell-script-to-show.html
Greets,
-supersonic.
Edited by supersonic, 27 June 2011 - 07:40 AM.
#34
Posted 27 June 2011 - 07:42 AM
#35
Posted 27 June 2011 - 07:44 AM
That's a definition that's in the new OutlookEX.au3The only thing is that I get the following error: WARNING: $olPrimaryExchangeMailbox: possibly used before declaration.
I will have to change the _OL_OOOSet function a bit. You will have to pass the name of the mailbox to the function. I will post what I have ASAP.Can you give me a clue how to change the OOO for an other user (issue 3), please? I have an user account which has access to all others' mail boxes... Is there a special syntax?
Edit: What's still missing are the extended functions if you are connected to a Exchange 2010 server (define start and end time of the OOO, set internal/external OOO).
A very good resource (german) is this site.
Greetings
Water
Edited by water, 27 June 2011 - 07:56 AM.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#36
Posted 27 June 2011 - 07:51 AM
Hi supersonic,Yes, I'm interested in manipulating Outlook rules, e. g. OOO -> mail redirection.
I will create a function that lists all rules with the corresponding action and exception functions. If this works well functions to add / modify rules will be added.
But keep in mind that the OutlookEX UDF offers functionality from the users point of view. To query/change anything you need write read/write access to the users mailbox if the user isn't logged on due to vacation etc.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#37
Posted 28 June 2011 - 07:20 PM
#38
Posted 28 June 2011 - 08:58 PM
Usually a compiled script gives a false positive but not a simple text file.
Edited by water, 18 July 2011 - 08:06 AM.
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
#39
Posted 29 June 2011 - 06:22 AM
Thank you - I'm really looking forward to test an upcoming release!
Thanks again for the link - I already know about this site.
It was a point to start my OOO script - unfortunately based on EWS.
Greets,
-supersonic.
Edited by supersonic, 29 June 2011 - 02:18 PM.
#40
Posted 29 June 2011 - 07:08 AM
a few rainy days are needed before I can post an enhanced version of the UDF
UDFs:
Active Directory (2012-10-12 - Version 1.3.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2012-10-07 - Version 0.9.0.0 released) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1 released) - Download - General Help & Support - Example Scripts
WordEX (2012-12-29 - Version 1.3 released) - Download
ExcelEX (2013-05-11 - Alpha 4 released) - Download
2 user(s) are reading this topic
0 members, 2 guests, 0 anonymous users




