Jump to content



Photo

OutlookEX UDF


  • Please log in to reply
332 replies to this topic

#21 Jaboowaki

Jaboowaki

    Seeker

  • Active Members
  • 41 posts

Posted 28 April 2011 - 03:27 PM

Rock n Roll, Thanks for the help. That taught me what I needed to know. Awesome.
Posted ImagePosted ImagePosted ImagePosted Image







#22 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 28 April 2011 - 03:28 PM

:unsure:

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 JCarson

JCarson

    Seeker

  • Active Members
  • 31 posts

Posted 04 May 2011 - 04:31 PM

My $0.02.

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 05 May 2011 - 10:03 PM

I do find this UDF useful, even to the extent of possibly assisting to improve it / add features.

Glad you like the new UDF :-) What do you think is missing right now? What should be added?

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 18 May 2011 - 02:05 PM

Version 0.2.0 has been released.

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 23 May 2011 - 01:03 PM

The last version of this UDF had more than 220 downloads - but only a few comments :unsure:

I would like to know

  • is the UDF useful for you?
  • do you use it in production?
  • do you miss any functions?
Any suggestions/comments are welcome!

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 16 June 2011 - 08:39 AM

I'm going to enhance the OutlookEX UDF. Functions for PST archives and mail signatures are in the making.

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 supersonic

supersonic

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 449 posts

Posted 17 June 2011 - 09:29 AM

Hi water,

I would like to see functions to manipulate OOO messages! :huh2:
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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 22 June 2011 - 09:08 AM

Hi supersonic,

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 23 June 2011 - 01:13 PM

Version 0.3.0 has been released.

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 23 June 2011 - 03:09 PM

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... :huh2:

Hi supersonic,

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 26 June 2011 - 05:28 PM

Anyone interested in Outlook rules (mail redirection 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


#33 supersonic

supersonic

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 449 posts

Posted 27 June 2011 - 07:36 AM

Hi water,

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 supersonic

supersonic

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 449 posts

Posted 27 June 2011 - 07:42 AM

Yes, I'm interested in manipulating Outlook rules, e. g. OOO -> mail redirection.

#35 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 27 June 2011 - 07:44 AM

Hi supersonic,

The only thing is that I get the following error: WARNING: $olPrimaryExchangeMailbox: possibly used before declaration.

That's a definition that's in the new OutlookEX.au3

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?

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.

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 27 June 2011 - 07:51 AM

Yes, I'm interested in manipulating Outlook rules, e. g. OOO -> mail redirection.

Hi supersonic,

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 benched42

benched42

    Seeker

  • Active Members
  • 12 posts

Posted 28 June 2011 - 07:20 PM

I'm having a problem with the OutlookEX UDF. My corporate antivirus is interpreting the OutlookEX.au3 file as a virus. I have tried changing names within the archive but each time I extract the one file that makes this entire UDF work, the file (renamed or not) is automatically quarantined and deleted by my antivirus. I'm using ESET NOD32 Antivirus v4 with virus signature database 6248 (20110628) on Windows 7 Professional 64-bit. I can't temporarily disable the antivirus because it's password protected by our Corporate IT Security team. Any thoughts/suggestions?
benched42Who lied and told you life would EVER be fair?

#38 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 28 June 2011 - 08:58 PM

If I understand you correctly as soon as you try to unzip the OutlookEX.au3 file it is quarantined? Do you get any additional information why the file was quarantined? What does your virus scanner think it found (a virus, a worm, a trojan ... what's its name?)
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 supersonic

supersonic

    Universalist

  • Active Members
  • PipPipPipPipPipPip
  • 449 posts

Posted 29 June 2011 - 06:22 AM

Hi water!

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 water

water

    ?

  • MVPs
  • 11,169 posts

Posted 29 June 2011 - 07:08 AM

Hi supersonic,

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