OutlookEX UDF

[water]

I do not know how they create the Outlook profiles in my company (by a script or GPO) but I think you can manually create the profile file and then call Outlook once using a command line parameter to use the profile file.

I think it could be "/importprf path:<filename.prf>" as described here.

How to create a profile is described here.

[crashnburn]

Is there a way to add a contact group? Id like to keep an up to date group list utilizing this and the AD function.

[water]

Can you please describe exactly what you want to do?

Do you wanto to create/modify the address list using the OutlookEX UDF?

[crashnburn]

I have a script that gets a list of all users in a specific group and pulls their emails. I would like to create a contact group in outlook with this list of emails. I would also like it update the list as emails are added or removed.

[water]

The _OL_Distlist* functions should do what you need.

[crashnburn]

Thank you water. I am not fully understanding how to use the _OL_DistListMemberAdd function. I have a 2D array, $names, that hold the users full name and their email address. I am trying to loop through the array and add them to the list but im at a lose as to how to properly layout this function. Here is what I put together:

_OL_DistListMemberAdd($outlook, $names[$a][0], Default, $names[$a][1])

$names[$a][0] = Users full name

$names[$a][1] = Users email address

 

UDPATE: I figured it out. I was not using _OL_ItemCreate to create the list first. Using that and replacing $names[$a][0] with the created item fixed it. Thank you very much for your help water.

Edited April 15, 2015 by crashnburn

[water]

[crashnburn]

Hit another speed bump. I am trying to use the _OL_ItemFind to get a handle on the DistList so I can check it for existing users but I am not getting the syntax correct. Im getting an @error 3 and @extended 4.

$search = _OL_ItemFind($outlook, "Contacts", $olDistributionListItem, "", "Sales Group")
If @error = 0 Then
    _ArrayDisplay($search)
Else
    MsgBox(48, "OutlookEX UDF: _OL_ItemFind Example Script", "Error finding the list. @error = " & @error & ", @extended: " & @extended)
EndIf

[water]

Try:  "*Contacts" for the folder name.

[crashnburn]

$search = _OL_ItemFind($outlook, "*\Contacts", $olDistributionListItem, "", "Sales Group")

Still returned @error 3 and @extended 4

[water]

Try this one:

$aResult = _OL_ItemFind($oOutlook, "*\Contacts", $olDistributionList, "", "DLName", "Sales Group", "EntryID")

[crashnburn]

 

Try this one:

$aResult = _OL_ItemFind($oOutlook, "*\Contacts", $olDistributionList, "", "DLName", "Sales Group", "EntryID")

 

Still returns @error 3 and @extended 4. I tried eliminating the optional parameters too but still got the same errors

$aResult = _OL_ItemFind($oOutlook, "*\Contacts")

Edited April 15, 2015 by crashnburn

[water]

@error 3, @extended 4 means: Specified folder could not be found.

Your contacts folder is named "Contacts"?

[crashnburn]

The default folder is named "Contacts (This computer only)". I had created another folder call "Contacts". I tried using "Contacts (This computer only)" and it no longer errors out, it just shows an empty array as there was nothing in there. I moved over the contact list and a few other contacts, now it brings up an array with all of the contacts, but not the list that I had created earlier.

Also, I converted it to this:

$aResult = _OL_ItemFind($oOutlook, "*\Contacts (This computer only)")

To eliminate any possible error while testing.

Edited April 15, 2015 by crashnburn

[water]

What does

$aResult = _OL_ItemFind($oOutlook, "*\Contacts (This computer only)", $olDistributionList, "", "DLName", "Sales Group", "EntryID")

return?

[crashnburn]

It returns a series of numbers and letters which im assuming is the handle for the list. I had entered the syntax incorrectly before I tried the condensed version. Thank you so much water for helping get through this, I really appreciate it!

[water]

[horphi]

Hello,

when i´m using ItemSearch, the columns Status and Categories are empty though the array gives a fine result.

In the other columns EntryId and Subjectare values existing.

Somebody know why?

Global $aItems =_OL_ItemSearch($oOutlook,$StrOutlook_Inbox,$strsql,"EntryId,Subject,Categories,Status")

Br

horphi

Edited July 31, 2015 by horphi

[water]

I assume you are searching for mails.
Status is not a valid property for a mail item.
Categories should return a string of assigned categories to the item.

What is the value of @error after _OL_ItemSearch?

[horphi]

I assume you are searching for mails.
Status is not a valid property for a mail item.
Categories should return a string of assigned categories to the item.

What is the value of @error after _OL_ItemSearch?

Hello Water,

yes i´m looking for mails. 

No error appears. It find the mails, but display only the subject and not the body....

Global $oOutlook = _OL_Open()

$isTerm = "ACS"
;~ $StrOutlook_Inbox ="\Posteingang"
If $iInBx <> GUICtrlRead($InBx) Then
   $iInBx = GUICtrlRead($InBx)
EndIf

$StrOutlook_Inbox = $iInBx

If $isTerm <> GUICtrlRead($sTerm) Then
   $isTerm = GUICtrlRead($sTerm)
EndIf

$strsql = '@SQL=urn:schemas:httpmail:subject ci_startswith ' & '''' & $isTerm & ''''

Global $aItems =_OL_ItemSearch($oOutlook,$StrOutlook_Inbox,$strsql,"EntryId,Subject,body")

BR

Edited August 1, 2015 by horphi