Jump to content

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here. X
X


Photo

OutlookEX UDF: Example scripts


  • Please log in to reply
77 replies to this topic

#1 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 09 March 2011 - 07:05 PM

In this thread we will post some useful example scripts based on the OutlookEX UDF.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts








#2 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 11 March 2011 - 05:19 PM

_OL_Example_NewMail_Event.au3 (2012-10-16)
When a new mail arrives a message box with SenderName and Subject is displayed.
Outlook has a lot of events you can act upon. This example script shows how to do this.

Tested on Windows 7 SP1 with Outlook 2010 32 Bit.

Attached File  _OL_Example_NewMail_Event.au3   1.16KB   946 downloads

History:

Spoiler


_OL_Example_SentMail_Event.au3 (2012-10-16)
When a mail is sent a copy is stored in the Sent Mail folder. This triggers the ItemAdd event for this folder.
The example script displays the Subject of the new item.
Based on this example script you could write your own mail archiving solution.

Attached File  _OL_Example_SentMail_Event.au3   1.26KB   479 downloads

History:
Spoiler

 
Get the currently used Outlook profile in Outlook XP, 2003, 2007, 2010, 2013 (2013-06-16 - provided by user orbs)
User orbs has posted a very helpful example script that returns the name of the currently used Outlook profile.
Outlook provides this functionality only for Outlook 2007 and later. This example works for every version!
 
 
PST to MSG converter (2013-06-17 - provided by user orbs)
User orbs has written a PST to MSG converter for Outlook. It converts an Outlook mail store to its elements as MSG files, maintaining folders structure.


Edited by water, 17 June 2013 - 08:34 AM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#3 JCarson

JCarson

    Seeker

  • Active Members
  • 31 posts

Posted 14 April 2011 - 03:02 PM

Doesn't seem to work for me.
Windows XP SP3
Outlook 2003 (all known updates)
Outlook is in cached exchange mode .. I don't really have a choice in this.

Thank you,

Carson

#4 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 14 April 2011 - 03:17 PM

Doesn't seem to work for me. Windows XP SP3 - Outlook 2003 (all known updates)

Unfortunately AutoIt Event handling doesn't work with Outlook 2003. You need at least Outlook 2007.

Edited by water, 24 April 2011 - 03:50 PM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#5 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 18 May 2011 - 02:07 PM

Version 0.2.0 of the UDF has been released.

Please test before using in production!

For download please see my signature.

Edited by water, 23 June 2011 - 10:02 PM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#6 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 23 June 2011 - 01:15 PM

Version 0.3.0 of the UDF has been released.

Please test before using in production!

For download please see my signature.

Edited by water, 23 June 2011 - 10:02 PM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#7 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 07 August 2011 - 02:19 PM

Version 0.4.0 has been released.

Please test before using in production!

For download please see my signature.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#8 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 18 September 2011 - 10:46 AM

Version 0.5.0 has been released.

Please test before using in production!

For download please see my signature.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#9 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 17 December 2011 - 11:52 AM

Version 0.6.0 has been released.

Please test before using in production!

For download please see my signature.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#10 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 09 April 2012 - 11:04 AM

Version 0.7.0 of the UDF has been released.

Please test before using in production!

For download please see my signature.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#11 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 19 April 2012 - 07:24 AM

Version 0.7.1.1 (Bugfixes) of the UDF has been released.

Please test before using in production!

For download please see my signature.

Edited by water, 19 April 2012 - 10:56 AM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#12 autoall

autoall

    Seeker

  • Active Members
  • 21 posts

Posted 28 April 2012 - 08:00 PM

Great work! really like your udf

#13 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 28 April 2012 - 09:25 PM

Thanks - glad you like it ;)

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#14 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 20 May 2012 - 04:16 PM

A new example has beend added: _OL_Example_SentMail_Event.au3
When a mail is sent a copy is stored in the Sent Mail folder and the ItemAdd event for the Sent Mail folder is triggered.
The example script displays the Subject of the new item.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#15 jaideept

jaideept

    Seeker

  • Active Members
  • 17 posts

Posted 08 August 2012 - 01:05 PM

please let me know how to automate outlook authentication popup.
Thanks,
Jaideep

#16 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 08 August 2012 - 01:11 PM

What do you mean by "outlook authentication popup"? Can you post a screenshot?

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#17 benjbong

benjbong

    Seeker

  • Active Members
  • 34 posts

Posted 10 August 2012 - 01:32 AM

This UDF is great. Is there a function to snarf all the addresses in the Global Address List?

#18 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 10 August 2012 - 06:40 AM

This UDF is great. Is there a function to snarf all the addresses in the Global Address List?

Moved your question to the help and support thread.

Edited by water, 10 August 2012 - 08:03 AM.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#19 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 10 August 2012 - 08:02 AM

please let me know how to automate outlook authentication popup.
Thanks,
Jaideep

Moved your question to the help and support thread.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts


#20 water

water

    ?

  • MVPs
  • 14,564 posts

Posted 28 August 2012 - 06:00 PM

Version 0.8.0.0 (Experimental) of the UDF has been released.

Please test before using in production!

For download please see my signature.

UDFs:
Active Directory (NEW: 2014-02-17 - Version 1.4.1.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2013-11-10 - Version 0.10.0.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2013-01-21 - Version 0.3.1.1) - Download - General Help & Support - Example Scripts
Excel (NEW: 2014-03-22 - Beta 5) - Download - General Help & Support - Example Scripts





3 user(s) are reading this topic

0 members, 3 guests, 0 anonymous users