OutlookEX UDF

[water]

_OL_AccountGet doesn't work with Outlook 2003. Outlook 2003 doesn't provide the needed COM methods and properties.

[codemaker]

_OL_AccountGet doesn't work with Outlook 2003. Outlook 2003 doesn't provide the needed COM methods and properties.

Is there any way to Edit (not Create) a single stickynote from outlook 2003?

[water]

If you have many notes how do you select the one to edit? By content, by ...?

[water]

The first line of a Note is set as the Subject (displayed under the symbol).

The following code searches for the subject and updates the body:

#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y

#include <OutlookEX.au3>

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)

Global $aItems = _OL_ItemFind($oOutlook, "*Outlook-UDF-TestTargetFolderNotes", $olNote, '[Subject] = "TestNote"', "", "", "EntryID,Subject,Body")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error searching notes. @error = " & @error & ", @extended = " & @extended)
_OL_ItemModify($oOutlook, $aItems[1][0], Default, "Body=" & "**" & $aItems[1][2])
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error modifying note. @error = " & @error & ", @extended = " & @extended)

_OL_Close($oOutlook)

[codemaker]

The first line of a Note is set as the Subject (displayed under the symbol).

The following code searches for the subject and updates the body:

#AutoIt3Wrapper_AU3Check_Parameters= -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6
#AutoIt3Wrapper_AU3Check_Stop_OnWarning=Y

#include <OutlookEX.au3>

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)

Global $aItems = _OL_ItemFind($oOutlook, "*\Outlook-UDF-Test\TargetFolder\Notes", $olNote, '[Subject] = "TestNote"', "", "", "EntryID,Subject,Body")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error searching notes. @error = " & @error & ", @extended = " & @extended)
_OL_ItemModify($oOutlook, $aItems[1][0], Default, "Body=" & "**" & $aItems[1][2])
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error modifying note. @error = " & @error & ", @extended = " & @extended)

_OL_Close($oOutlook)

I get the following error

Error searching notes. @error = 3, @extended = 4

Are you sure that this is the right path "*\Outlook-UDF-Test\TargetFolder\Notes" I'm not calling CreateTestEnvironmen....

If I add the _OL_ErrorNotify(1)

COM Error Encountered in test.au3

OutlookEx UDF version = 0.9.0

@AutoItVersion = 3.3.8.1

@AutoItX64 = 0

@Compiled = 0

@OSArch = X86

@OSVersion = WIN_XP

Scriptline = 1212

NumberHex = 80020009

Number = -2147352567

WinDescription =

Description = The operation failed. An object could not be found.

Source = Microsoft Office Outlook

HelpFile =

HelpContext = 0

LastDllError = 0

========================================================

[water]

Are you sure that this is the right path

If you want to search your own Notes folder I assume you need to replace it with "*Notes".

[codemaker]

If you want to search your own Notes folder I assume you need to replace it with "*Notes".

Thanks it works

[water]

Glad it works

[GoogleDude]

Nice UDF. Is there a way to Update or Refresh a folder with this UDF? Send and Receive does not always update the contents of a folder unless I click on "Update Folder" from the outlook toolbar? For whats its wirth the folder in question is a Exchange Mailbox folder.

Thanks,

GD

[water]

Which version of Outlook do you use?

[Tjalve]

I'm running Outllok 2010 and I have created a contact with a jpg picture and it works just fine.

Which Outlook version do you run?

It works if you scroll down the list, and back up. Som everything works fine

Thanx

[water]

So it's just a screen updating problem? Strange!

[minimen456]

Let's say I have folder "Inbox" and It has subfolder "Subfolder". I need to put text of letters in "Subfolder" into the Array. For exemple $aArray[0] = "text of first letter", $aArray[1] = "text of second letter". How can I do it? Can you give me an exemple?

[water]

Moved your question to the OutlookEx

This thread is to discuss new functions, requests etc.

[water]

Anyone interested to see User Defined Properties (properties you define yourself and add to items) supported by the OutlookEX UDF?

[ptrex]

Hi Water,

Yes definitely !

I have developed many custom Forms on Exchange which uses custom Properties a lot.

This way I could access these, correct ?

Rgds

ptrex

[water]

Hi ptrex,

So far I have written a function to add user properties to items and folders. Plus a function to remove them.

The existing functions to search for items (_OL_ItemFind), access the properties of an item (_OL_ItemGet) and set the value of properties (_OL_ItemModify) need to be changed too.

[ptrex]

Hi Water,

Thanks for the info.

I did not know the (_OL_ItemGet) could access custom properties ?

I was in the understanding it could access only standard properties.

I will test it soon.

rgds

ptrex

[water]

Sorry, wasn't clear enough.

_OL_ItemGet needs to be enhanced to support user properties too.

[water]

If you like it can post the functions _OL_UserpropertiesAdd, _OL_UserpropertiesGet and _OL_UserpropertiesRemove for you to play with.