move emails to a folder in outlook in a 1st in 1st out basis using _OL_ItemMove

[TheOne23]

Hi MVPs and Experts,

May I seek your assistance on how to move emails from a folder to another folder in a 1st in 1st out basis.

Below is my sample script.

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

$aItems = _OL_ItemFind($oOutlook, "ronald.paggao@infosys.com\Inbox\!!! IJP\", $olMail, "[UnRead]=true", "", "", "EntryID", "", 2)
;_ArrayDisplay($aItems)
if @error then MsgBox(0,"Error: ", @error)
;$iRows = (UBound($aItems, $UBOUND_ROWS))-1
$iRows = (UBound($aItems)-1)

;MsgBox(0,"",$iRows)

If $iRows > 1 Then

   _OL_ItemMove($oOutlook, $aItems[1][0], Default, "ronald.paggao@infosys.com\Inbox\!!! IJP_test\")

EndIf

 

[water]

What do you mean by "first in first out"? Moving an item does not change the date/time of arrival.

[TheOne23]

Hi Water,

it means that the _OL_ItemMove function should move the oldest email first before the newest or newly arrived unread email.

[water]

It does not matter in which order you move the mails. The order they get displayed is determined by the file you select to sort the items in the explorer.

[TheOne23]

Hi Water,

You mean I can sort the mails in that folder then the function will select what is in the index [1] first to move. Am I getting you right Water?

 

 

[water]

The OutlookEX UDF ignores how items get displayed in the GUI. You can sort items by size or date - it doesn't change the order how _OL_ItemFind fills the array.

[TheOne23]

Hi Water,

Make sense to me. Does _OL_ItemFind can sort the array to fill in the oldest mail first in the 1st index?

[water]

Please check the OutlookEx.htm help file. _OL_ItemFind provides a sort parameter.

[TheOne23]

Hi Water,

 

Thank you for your usual support and it is greatly appreciated.

I will check and review it.

 

Thank you.

[water]

 

[Skysnake]

My own issue...

I have PSTs which are becoming unmanageable

The idea is to make a simple GUI (Listview) which can combine non-Outlook data and include emails based on criteria.  Manage them in the GUI (delete / reply etc) and update to Outlook.

So the issue would be to manage the items in the GUI while using the PST as a database.

Ideas on how to do this? What would the key be?

[water]

I think it would be sensible to create a new topic so we do not mix this two completely different subjects.
I can then post my ideas there

[Skysnake]

Who shall start?

 

[water]

Always the one who asks  

[TheOne23]

Hi Water,

 

I read the OutlookEX.au3 under _Ol_ItemFind and tried to sort it. It does Sort the items in the Array but once _ol_Itemmove is initiated, it still moves the newest item rather than what I need like moving the oldest first.

Anything that you might think can do this?

 

Thank you in advance.

[TheOne23]

Hi Water,

I already figured it out.

This solved my issue. I used to count the numbers of array and since it is in a descending order then I got the EntryID of the highest Index and make it as my primary focus to pick up.

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

$aItems = _OL_ItemFind($oOutlook, "ronald.paggao@infosys.com\Inbox\!!! IJP\", $olMail, "[UnRead]=true", "", "", "EntryID", "EntryID,True", 2)

if @error then MsgBox(0,"Error: ", @error)
$iRows = UBound($aItems)-1

If $iRows > 1 Then

   _OL_ItemMove($oOutlook, $aItems[$iRows][0], Default, "ronald.paggao@infosys.com\Inbox\!!! IJP_test\")

EndIf