OutlookEX UDF - Help & Support (III)

[water]

The problem is caused by not all items in the sent folder having the ToAddress property.
I'm thinking about a way to solve the issue

[MikeFez]

Thanks for the brainpower water... I've been scratching my head wondering if this is even possible!

[water]

Unfortunately it is much more complex:
The sent mail item does not directly hold the recipients mail addresses. It holds a collection of recipients. Each item of this collection has a different way to hold the recipients mail address depending of the type of recipient (Exchange address list, local contact, SMTP address ...).
So you would need to retrieve all mail items from the "Sent Items "folder and then process each item separately.

Is this what you want?
If yes I try to post an example.

[MikeFez]

Hi water,

It sounds like that's the only way it would be possible then - if you don't mind, I'd love to see an example.  

I can definitely foresee myself creating a process of "scanning sent items", compiling the email addresses into a list with a timestamp, and during future scans having it continue finding sent addresses from that timestamp on - allowing myself to generate growing lists as to ease the burden on outlook.

[water]

Outlook keeps a record of all recipients you have sent a mail to. Will check how it is called and how to access.

Edited March 13, 2016 by water

[water]

The "Recipient Cache" can't be accessed using COM.

But you could grab the Outlook send event and store the recipients data wherever you want. See the _OL_Example_SentMail_Event.au3 in the Example Scripts section for Outlook.

 

[MikeFez]

Hmm. That sounds like it would miss emails sent from other sources, such as through a mobile app - I've implemented it for the time being though. Thanks for the help!

[water]

Correct, events are sent from Outlook. Such a script would hence miss all mails sent to your Exchange account by other means.

[water]

But you could combine the event approach with a daily/hourly run to check the sent mails folder.

[MikeFez]

Sorry for the late reply - your last comment makes absolute sense. Thanks so much for your help!

[water]

Glad to be of service  

[davzell13]

hello all,

is it possible to find the incoming and outgoing server with the associate port ? 

thanks in advance

[water]

Not with this UDF or the COM interface. You would need to process the Outlook profile.
What do you need this information for?

[davzell13]

i want to do an audit of some computer and save different information in a txt file.

Especially the name of my server and the logon username.

[water]

Version 1.2.0.0 of the UDF has been released.

Please test before using in production!

For download please see my signature.

[Ktulu789]

Hi, I was trying to get a list of mails on a mailbox from a certain date, say yesterday.

_OL_ItemFind($oOutlook, "*", $olMail, "[received]='yesterday'", "", "", "Subject,Body", "", 1)

Ultimately I want to search for all mails from past year (1/1/15-12/31/15). But I can't get this to work with dateTodate. Not even with a single day. Tried YMD YDM DMY (locale) and MDY, all of them with D, DD, M, MM, YY and YYYY.

While at it I tried with "yestarday" too.

Found a way to it with AQS "sent:11/1/06..11/5/06" but couldn't find a way to tell the function which language I'm using.

Probably I'm doing it all wrong and maybe _OL_ItemFind is not meant for dates search so after some hours of trying, googling and reading I humbly came here for help

If anybody can point me in some direction I'll certainly be very grateful! 

I'm using Outlook 2010 english with AutoIt v. 3.3.10.2 and the latest OutlookEX UDF.

 

Unrelated question: when creating the test environment I get error 510 for no apparent reason, tested also with Outlook 2003 and 2007 so I finally commented the failing UDF line, 6247)

; Note
    _OL_ItemCreate($oOL, $olNoteItem, $oSourceFolderNotes, "", "Width=350", "Body=TestNote")
;~  If @error Then Return SetError(510, @error, 0)

An empty note is created instead. Why does this happen?

Edited June 1, 2016 by Ktulu789
Minor

[water]

Date handling is a bit complex in Outlook.
The wiki has an example how to specify dates:

[Received]>='2016-01-01 00:01' And [Received]<='2016-12-30 23:59'

should return mails received this year.

Error 510 is caused by a bug I'm currently about to fix.

[water]

This new version of function __OL_CheckProperties should solve the 510 problem:

Func __OL_CheckProperties($oItem, $aProperties, $iFlag = 0, $bItemProperties = True)

    Local $aTemp, $iIndex, $iEnd, $oProperty, $bUserProperties = True
    If $iFlag = 1 Then
        $iIndex = 1
        $iEnd = $aProperties[0]
    Else
        $iIndex = 0
        $iEnd = UBound($aProperties) - 1
    EndIf
    If $oItem.Class = $olNote Then $bUserProperties = False ; Note items only support the ItemProperties property
    For $iIndex = $iIndex To $iEnd
        $aTemp = StringSplit($aProperties[$iIndex], "=")
        If $aTemp[1] <> "" Then
            SetError(0)
            If $bUserProperties Then
                $oProperty = $oItem.UserProperties.Find($aTemp[1], Not $bItemProperties) ; Search Itemproperties or UserProperties
            Else
                $oProperty = $oItem.ItemProperties() ; Get the property collection
                $oProperty = $oProperty.Item($aTemp[1]) ; Get the named property
                If Not IsObj($oProperty) Then SetError(1) ; Set error if property not found
            EndIf
            If @error Then Return SetError(Int(10 & StringRight("0" & $iIndex, 2)), 0, 0) ; Property not found
            If Not ($aTemp[1] == $oProperty.Name) Then Return SetError(Int(11 & StringRight("0" & $iIndex, 2)), 0, 0) ; Case doesn't match
        EndIf
    Next
    Return 1

EndFunc   ;==>__OL_CheckProperties

Could you please modify the UDF and tell me if it works for you?

[Ktulu789]

On 6/1/2016 at 4:03 AM, water said:

Date handling is a bit complex in Outlook.
The wiki has an example how to specify dates:

[Received]>='2016-01-01 00:01' And [Received]<='2016-12-30 23:59'

should return mails received this year.

Error 510 is caused by a bug I'm currently about to fix.

So I guess that it didn't work for me while trying it because it doesn't work with single days.

$aItems = _OL_ItemFind($oOutlook, "*", $olMail, "[Received]='2016/01/06'", "", "", "Subject", "", 1)

---------------
On the 510 error, the new __OL_CheckProperties worked perfectly. Now the note was created and populated! Thanks a lot for your help, Water!! 

[water]

A single day is still a period of time. So you would use something like:

[Received]>='2016-01-01 00:01' And [Received]<='2016-01-01 23:59'

You can't omit the HH:MM part and just specify YYYY-MM-DD.