OutlookEX UDF - Help & Support (III)

[water]

What came to my mind when I was at the beach: How would you specify credentials when accessing a internet calendar?

[GreenCan]

  On 12/27/2014 at 2:04 PM, water said:

What came to my mind when I was at the beach: How would you specify credentials when accessing a internet calendar?

Sunny beach?  It's freezing cold out here... it snowed 10 cm yesterday, -4 °C in Belgium.  Beautiful.

When subscribing to an ical (na Internet Web address that begins with webcal:// (in my case it is https://), and ends with a file name that has the .ics file extension), I you get 3 prompts

1. Presuming Outlook is installed on the PC, the first prompt lets you choose between Outlook or another application, obviously select Outlook.

2. Microsoft Outlook then prompts 'Add this Internet Calendar to Outlook and subscribe to updates'. 

3. When you click yes, you get the sign-in for the webserver connection (to the cal url), enter the credentials for the webcal access and click OK

The Webcal is then imported and sync-ed automatically in Outlook (every 10 minutes), no need to retype the credentials, Outlook remembers this.

There seems also to be no limit in the amount of iCals that I can add to Outlook.

GreenCan

[water]

Can you please post the full _OL_FolderAccess statement and a screenshot of Outlook folder pane showing the accessed iCal?

[GreenCan]

  On 12/28/2014 at 5:33 PM, water said:

Can you please post the full _OL_FolderAccess statement and a screenshot of Outlook folder pane showing the accessed iCal?

I'll do...

[GreenCan]

_OL_FolderAccess for Internet calendars (iCal) resolved

see post 218 for some examples.

Thank you for your help water

 

[rayusrnm]

Maybe I am using the function wrong but I am trying to create a folder under the Inbox.

I am trying to get the $iFolderType so I can execute the _OL_CreateFolder

The results from _OL_FolderAccess($outlook,"*Inbox") is the following

Row 0 = 5

Row 1 = Blank

Row 2 = 0

Row 3 = very long string

Row 4 = very long string

Row 5 = myemailaddressInbox

 

So if I try to execute $a=_OL_FolderCreate($outlook,"Test123",$olMailItem)

Result of $a is 0 and folder does not get created.  

 

I am trying to create a folder and then copy any mail if it is newer than 30 days to this created folder.  Then I want to export this folder to a pst file.  

 

The test machine that I am using is my account using Outlook 2013.

 

Thanks so much for such a useful udf.  

[water]

Try

$oFolder = _OL_FolderCreate($outlook, "Test123", $olFolderInbox, "*\Inbox")

[rayusrnm]

That did the trick!!  

Thanks again!

[water]

[HighlanderSword]

Hello,

I'm having an issue when using the function _OL_ItemSearch, most of the times it works ok but other times it fails with the error message

"Error : Array variable has Incorrect number of subscripts or subscripts dimension range exceeded"

When I ge tthe error and re-run the Code that has the issue and it works with no isues , so I'm having challenges trying to trace down

what is causing the issue, Below is the code that is having the issue.

Func Grab_email()
Dim $aItems

Global $oOutlook = _OL_Open()

 _OL_ErrorNotify(2)

$Local_Folder = _OL_FolderAccess($oOutlook, "", $olFolderInbox)

$StrOutlook_Inbox ="Mailbox - Schrader, Paul KBB Temp HoldingCDSN"

$strsql ='"urn:schemas:httpmail:read" =0'

$strsql ="@SQL=" & $strsql

'Process dies in the do loop ,  as it never gets to the write to log after the do loop before presenting the error
do
$aItems=_OL_ItemSearch($oOutlook,$StrOutlook_Inbox,$strsql,"EntryID")
_FileWriteLog(@ScriptDir & "CDSN.log", "Waiting  for email to be here")
ConsoleWrite("waiting for emails to equal 67")
until UBound($aItems) = 67

_FileWriteLog(@ScriptDir & "CDSN.log", "Got the emails Moving to Processing Stage")

'More code below to process emails

End Func

[water]

Which version of the OutlookEX UDF do you run?

[water]

Another question.

Does the problem only occur when new items arrive in the inbox while _OL_ItemSearch is running?

[water]

Another question:

What do you try to achieve with your script? Wait until 67 unread mails are in your inbox?

[HighlanderSword]

Hello,

Im running the current version 1.0.0.0.

The issues occurs while thjr search is running.

The Script is waiting for the 67 emails to be delivered to the specfied folder.

[water]

An alternative would be function _OL_ItemFind. That's the basic search function whereas OL_ItemSearch is the advanced search function.

_OL_ItemFind once crashed whena new mail arrived while Outlook processed the current query. Maybe _OL_ItemSearch has a similar problem.

Running a search function in a infinite loop puts a heavy load on your PC.

Maybe waiting for the event that is triggered by a new mail would be a better way. In the Example Scripts forum you will find an example (please check my signature for the link).

[HighlanderSword]

The trigger for the event is before the procedure is called, its a proces that creates 67 email to be sent to me.

When the procedure is called to process the emails their is about a 15 second wait ( the do loop) it does as the last 2 emails are comming into the email account

I will try the suggestion about using _ol_itemfind and see if that exhibits the same issues ( this will take time as the issue  occurs about 2 % of the time the process is run)

[water]

I was talking about Outlook events. Every incoming mail triggers such an event.

A script would process 67 events then call a function to process the whole bunch in one go.

[HighlanderSword]

Hello,

Ive run into a neew issue I have an EXE created that will send an email with no issues when run via the Scite editor and running  the exe manually.

When I got to Schedule in Task Schedule and schedule the exe to run it fails.

User that is running the task is ad administrator and the option selected specfies run when user is logged on

So I added an error capture return after using _ol_open and I get the errors of

Extended = -2147221164

Error =1

Any Ideas

Edited February 2, 2015 by HighlanderSword

[water]

The error code stands for '80040154 Class not registered'.

Means: The class is unknown to the user running the script. I assume you use the system account to run the script in the task scheduler?

[HighlanderSword]

I was not running as they system account in Task schedule was running as the user logged in that was an admin.

I changed the scheduled task to use the system account and now the process gives no errros at all and never finishes running nor delivers the email