OutlookEX UDF

[BrewManNH]

Double click on that OutLookEx, the files are inside of it. That's the part that gets messed up, it looks like there's only one file in it, but the files are inside that folder and you can't just extract that folder to somewhere because it won't work that way.

[water]

I wonder why now and then people seem to have problems unzipping my UDFs (AD, Outlook, Word, Excel, ExcelChart). I use ordinary Windows 7 to send all files to a zip-compressed folder.

Maybe there is a problem with the firewall, HIPS or anti virus programs?

Can you try from another PC?

[Woks]

Double click on that OutLookEx, the files are inside of it. That's the part that gets messed up, it looks like there's only one file in it, but the files are inside that folder and you can't just extract that folder to somewhere because it won't work that way.

 

Owh! That's fine!

I unzip the downloaded file, that generates an OutlookEX file, then I open this file with an unzipper tools and I see all necessary files!

Seems to be zipped two times.

Thanks a lot for your help and wish you a nice weekend.

 

I wonder why now and then people seem to have problems unzipping my UDFs (AD, Outlook, Word, Excel, ExcelChart). I use ordinary Windows 7 to send all files to a zip-compressed folder.

Maybe there is a problem with the firewall, HIPS or anti virus programs?

Can you try from another PC?

 

Was the same for 2 workstations, but they have nearly the same configuration, so...

As said just above, file seems to be zipped 2 times for me (one with the zip extenion, and the second one without extension).

Thanks for your UDF! And wish you a nice weekend too.

[water]

Strange!

I just downloaded the file in Ubuntu and the file doesn't seem to be zipped twice

[water]

Version 0.10.0.0 of the UDF has been released.

Please test before using in production!

For download please see my signature.

[ibigpapa]

I'm getting an error when running this to find items.   If I change the ReturnProperties from "To" to "To,CC"  there is no error

$oOutlook = _OL_Open()
$aItems = _OL_ItemFind($oOutlook,"*",$olMail,"","","","To","",1)

 

C:PROGRA~2AutoIt3IncludeoutlookEX.au3 (5923) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:

If UBound($avArrayTarget, 0) > 1 Then $avArrayTarget[0][1] = UBound($avArrayTarget, 2)

If UBound($avArrayTarget, 0) > 1 Then ^ ERROR

 

• Autoit Version
  • 3.3.8.1
• OutlookEX Version
  • 0.10.0.0

 

 

[water]

The crash is in the internal function __OL_ArrayConcatenate. I need to investigate the problem ...

Edited January 3, 2014 by water

[ibigpapa]

The crash is in the internal function __OL_ArrayConcatenate. I need to investigate the problem ...

Yeah,  Tried to debug by putting consolewrite and _array_displays in to determine values but no bueno.  Always get the error and never get any text written to console.  Hope you can debug further than I.  If so what IDE are you using and what was the process you follow?  Always looking to improve upon my technique.

[water]

I'm just using SciTE.

First I will try to reproduce the error, then I will check the intermediate results before calling __OL_ArrayConcatenate.

[ibigpapa]

Ok found a few other errors when i attempt to return these properties (i'm pulling the properties from http://msdn.microsoft.com/en-us/library/office/aa210946(v=office.11).aspx)

• FlagStatus
• Links
• FlagDueBy
• FlagIcon
• EnableSharedAttachments
• IsIPFax
• HasCoverSheet

#include<outlookEX.au3>
#include<outlookExConstants.au3>
#include<Array.au3>
$oOutlook = _OL_Open()
$Folder = "*"
$objectClass = $olMail
$Filter = ""
$searchName = ""
$searchValue = ""

$returnProperties = "To,FlagStatus"
;$returnProperties = "To,Links"
;$returnProperties = "To,FlagDueBy"
;$returnProperties = "To,FlagIcon"
;$returnProperties = "To,EnableSharedAttachments"
;$returnProperties = "To,IsIPFax"
;$returnProperties = "To,HasCoverSheet"
$sort = ""
$flagIncludeSubfolders = 1
$flagRow1containheadings = 2
$flagOnlyReturnCount = 4
$flags = $flagIncludeSubfolders

$aItems = _OL_ItemFind($oOutlook,$Folder,$objectClass,$Filter,$searchName,$searchValue,$returnProperties,$sort,$flags)
_OL_Close($oOutlook)

 

 

C:PROGRA~2AutoIt3IncludeoutlookEX.au3 (2788) : ==> Object referenced outside a "With" statement.:

$aItems[$iCounter][$iIndex - 1] = $oItem.ItemProperties.Item($aReturnProperties[$iIndex]).value

$aItems[$iCounter][$iIndex - 1] = $oItem.ItemProperties.Item($aReturnProperties[$iIndex])^ ERROR

 

 

 

Just in case anyone wants to know what MailItem.properties work on version 0.10.0.0 and Outlook 2013 Here is the list of working

• Actions
• AlternateRecipientAllowed
• Application
• Attachments
• AutoForwarded
• AutoResolvedWinner
• BCC
• BillingInformation
• Body
• BodyFormat
• Categories
• CC
• Class
• Companies
• Conflicts
• ConversationIndex
• CreationTime
• DeferredDeliveryTime
• DeleteAfterSubmit
• DownloadState
• EntryID
• ExpiryTime
• FlagRequest
• FormDescription
• GetInspector
• HTMLBody
• Importance
• InternetCodepage
• IsConflict
• ItemProperties
• LastModificationTime
• MarkForDownload
• MessageClass
• Mileage
• NoAging
• OriginatorDeliveryReportRequested
• OutlookInternalVersion
• OutlookVersion
• Parent
• Permission
• PermissionService
• ReceivedTime
• RecipientReassignmentProhibited
• Recipients
• ReminderOverrideDefault
• ReminderPlaySound
• ReminderSet
• ReminderSoundFile
• ReminderTime
• RemoteStatus
• ReplyRecipientNames
• ReplyRecipients
• Saved
• SaveSentMessageFolder
• SenderEmailAddress
• SenderEmailType
• SenderName
• Sensitivity
• Sent
• SentOn
• SentOnBehalfOfName
• Session
• Size
• Subject
• Submitted
• To
• UnRead
• UserProperties
• VotingOptions
• VotingResponse

Edited December 31, 2013 by ibigpapa

[water]

The crash is in the internal function __OL_ArrayConcatenate. I need to investigate the problem ...

It's a bug which occurres when the arrays to concatenate only have 1 column.

Replace line 5923 with:

If UBound($avArrayTarget, 0) > 1 And UBound($avArrayTarget, 2) > 1 Then $avArrayTarget[0][1] = UBound($avArrayTarget, 2)

[water]

Ok found a few other errors when i attempt to return these properties (i'm pulling the properties from http://msdn.microsoft.com/en-us/library/office/aa210946(v=office.11).aspx)

• FlagStatus
• Links
• FlagDueBy
• FlagIcon
• EnableSharedAttachments
• IsIPFax
• HasCoverSheet

#include<outlookEX.au3>
#include<outlookExConstants.au3>
#include<Array.au3>
$oOutlook = _OL_Open()
$Folder = "*"
$objectClass = $olMail
$Filter = ""
$searchName = ""
$searchValue = ""

$returnProperties = "To,FlagStatus"
;$returnProperties = "To,Links"
;$returnProperties = "To,FlagDueBy"
;$returnProperties = "To,FlagIcon"
;$returnProperties = "To,EnableSharedAttachments"
;$returnProperties = "To,IsIPFax"
;$returnProperties = "To,HasCoverSheet"
$sort = ""
$flagIncludeSubfolders = 1
$flagRow1containheadings = 2
$flagOnlyReturnCount = 4
$flags = $flagIncludeSubfolders

$aItems = _OL_ItemFind($oOutlook,$Folder,$objectClass,$Filter,$searchName,$searchValue,$returnProperties,$sort,$flags)
_OL_Close($oOutlook)

C:PROGRA~2AutoIt3IncludeoutlookEX.au3 (2788) : ==> Object referenced outside a "With" statement.:

$aItems[$iCounter][$iIndex - 1] = $oItem.ItemProperties.Item($aReturnProperties[$iIndex]).value

$aItems[$iCounter][$iIndex - 1] = $oItem.ItemProperties.Item($aReturnProperties[$iIndex])^ ERROR

 

Just in case anyone wants to know what MailItem.properties work on version 0.10.0.0 and Outlook 2013 Here is the list of working

• Actions
• ...
• VotingResponse

 

Is this something I should investigate?

Edited January 3, 2014 by water

[gaogao]

how can I work on a PST file with these functions?

I would like to create an empty PST, then create folders and copy messages based on specific criteria.

I can't find a way to open the empty PST I'm creating with 

$oDestinationPST = _OL_PSTCreate($oOutlook, $sDestinationFile, "AdditionalPST")

as this call fails:

$oFolder = _OL_FolderAccess($oOutlook, "\\AdditionalPST")

as well as this one:

$oFolder = _OL_FolderCreate($oOutlook, "Additional Data", $olFolderInbox, "\\AdditionalPST\")

[water]

Use something like this to create a PST and folders:

#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 $oPST = _OL_PSTCreate($oOutlook, "C:\temp\Additional.PST", "AdditionalPST")
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_PSTCreate Example Script", "Error creating 'C:\temp\Additional.PST' archive. @error = " & @error & ", @extended: " & @extended)
MsgBox(64, "OutlookEX UDF: _OL_PSTCreate Example Script", "Archive 'C:\temp\Additional.PST' successfully created!")

Global $oFolder = _OL_FolderCreate($oOutlook, "Test-Folder\Sub-Test-Folder", $olFolderInbox, $oPST)
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OL_PSTCreate Example Script", "Error creating foldrs. @error = " & @error & ", @extended: " & @extended)
MsgBox(64, "OutlookEX UDF: _OL_PSTCreate Example Script", "Folders successfully created!")
_OL_Close($oOutlook)

[gaogao]

many tks for the prompt reply.

what if you want to set the new folder as the current folder, ie:

Global $oFolder = _OL_FolderCreate($oOutlook, "Test-Folder\Sub-Test-Folder", $olFolderInbox, $oPST)

_OL_FolderSet($oOutlook, "\\AdditionalPST\Test-Folder\Sub-Test-Folder")

This fails for me, as well as the following:

Global $oFolder = _OL_FolderCreate($oOutlook, "Test-Folder\Sub-Test-Folder", $olFolderInbox, $oPST)

Global $arFolder = _OL_FolderAccess($oOutlook, "\\AdditionalPST\Test-Folder\Sub-Test-Folder")

[water]

"Current folder" means you to select this folder and display the content to the user?

[gaogao]

yes, and then use the newly created folder as base for a "FolderCopy" operations

[water]

But the target folder doesn't need to be displayed for a folder copy operation.

Simply use function _OL_FolderCopy.

To display the folder you would simply use:

$oFolder.Display

[gaogao]

right, I was trying to set it as default and display it since I was not able to make FolderCopy work across PSTs, and I thought the reason being an incorrect syntax for the destination folder.

All I'm interested in is to make the following work:

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

Global $iPST = _OL_PSTAccess($oOutlook, "C:\temp\Source.PST", "SourcePST")
If @error <> 0 Then Exit ConsoleWrite("Error accessing 'C:\temp\source.PST' file @error = " & @error & ", @extended: " & @extended & @crlf)
ConsoleWrite("File 'C:\temp\Source.PST' successfully opened!" & @crlf)

Global $oPST = _OL_PSTCreate($oOutlook, "C:\temp\Dest.PST", "DestPST")
If @error <> 0 Then Exit ConsoleWrite("Error creating 'C:\temp\dest.PST' file @error = " & @error & ", @extended: " & @extended & @crlf)
ConsoleWrite("Archive 'C:\temp\Dest.PST' successfully created!" & @crlf)

_OL_FolderCreate($oOutlook, "Test-Folder\Sub-Test-Folder", $olFolderInbox, $oPST)
If @error <> 0 Then Exit ConsoleWrite("Error creating folders. @error = " & @error & ", @extended: " & @extended & @crlf)
ConsoleWrite("Folders successfully created!" & @crlf)

_OL_FolderCopy($oOutlook, "\\SourcePST", "\\DestPST\Test-Folder\Sub-Test-Folder")
If @error <> 0 Then Exit ConsoleWrite("Error copying folders. @error = " & @error & ", @extended: " & @extended & @crlf)
ConsoleWrite("Folders successfully copied!" & @crlf)

[water]

Where does this code return an error now?