anton

Water, I have downloaded and installed the OutlookEX. I also looked over the Wiki and Examples. I am trying to auto populate a shared calendar with data from our ERP system. This calendar is used by our install crew who access it via OWA on their smartphones. We may have 30 - 70 install jobs active at any one time. The ERP system has a SQL backend and uses Crystal for reports. I would like the calendar to be a reflection of jobs that are active in the system. The jobs move through production and the status changes as the job progresses. I would like to keep the calendar up-to-date with the latest job status. Once the job is marked complete in the ERP system I would like for the entry to be removed. So here are my questions. How would you recommend getting the data from the ERP to the shared calendar? Perhaps schedule a Crystal CSV report drop to a hot folder and schedule a script using OutlookEX to repopulate a fresh calendar every time. Every 15 min would be fine. Build a SQL query to return data to the script and then process form there? Would you recommend rebuilding the calendar of 30-70 entries every time or a update existing entries based off CSV file or Triggered SQL changes? Any insight is much appreciated. Thanks for the sweet UDFs! Anton

Thanks for responding. I figured it out. AutoIt captures keys that are set to be used as hotkeys. So... HotKeySet("+2", "hotkey") Means I can't type Shift-2. Or in this case the @ symbol.

OK I have searched high and low and I am unable to find the answer. I have recently updated a script and when I run it I am unable to type the "@" symbol. I must be in the dark or completely missed something. Any help would be greatly appreciated. Thanks!

Thanks for the reply Authenticity it helped me get on the right track. I have taken a sample script and modified it to suit my needs, one problem, I keep getting an error? This is what happens.... CODEDim $objApp Dim $objNS Dim $colFolders Dim $objFolder Dim $olAppointmentItem $oFolder = _GetFolder ("Public Folders\All Public Folders\test") Func _GetFolder($strFolderPath) Dim $i $arrFolders = StringSplit($strFolderPath, "\") $objApp = ObjCreate("Outlook.Application") $objNS = $objApp.GetNamespace("MAPI") $objFolder = $objNS.CreateItem($olAppointmentItem) $objFolder.Location = "" $objFolder.Subject = "subject here" $objFolder.Body = "text" $objFolder.Start = "2/12/2009" $objFolder.AllDayEvent = 1 $objFolder.Save ConsoleWrite(ObjName($objFolder) & @CR) If IsObj($objFolder) Then For $i = 2 To $arrFolders[0] $colFolders = $objFolder.Folders $objFolder = $colFolders.Item($arrFolders[$i]) If Not IsObj($objFolder) Then ExitLoop EndIf Next EndIf Return $objFolder EndFunc This is the error I cannot get around? >Running:(3.2.2.0):C:\Program Files\AutoIt3\autoit3.exe "C:\Documents and Settings\anton.j\Desktop\auto it\temp1.au3" C:\Documents and Settings\anton.j\Desktop\auto it\temp1.au3 (22) : ==> The requested action with this object has failed.: $objFolder = $objNS.CreateItem($olAppointmentItem) $objFolder = $objNS.CreateItem($olAppointmentItem)^ ERROR What am i missing??? Any help would be great! Thanks, Anton

Hi All, I am trying to make a script that creates a calendar appointment in the public folder on a certian calendar. The calendar is called test and every time I try to run the script it errors when it triest to go to the public folder path? What am I doing wrong? I am new to all this and any help is appreciated. Anton #include <Date.au3> Const $olAppointmentItem = 1 Dim $objOL, $session, $calendar $path = ("\\Public Folders\All Public Folders\test") $objOL = ObjCreate("Outlook.Application") $session = $objOL.GetNameSpace("MAPI") $calendar = $session.GetDefaultFolder($path) $calendar.CreateItem ($olAppointmentItem) $calendar.Location = "" $calendar.Subject = "subject here" $calendar.Body = "text" $calendar.Start = "2/12/2009" $calendar.AllDayEvent = 1 $calendar.Save