lod3n Posted November 8, 2006 Share Posted November 8, 2006 Not sure if these have already been posted, but this makes translating Outlook VBA code to AutoIt a breeze.expandcollapse popup; Outlook Constants ; OlActioncopy Like Constants Global Const $olReply = 0 Global Const $olReplyAll = 1 Global Const $olForward = 2 Global Const $olReplyFolder = 3 Global Const $olRespond = 4 ; OlActionReplyStyle Constants Global Const $olOmitOriginalText = 0 Global Const $olEmbedOriginalItem = 1 Global Const $olIncludeOriginalText = 2 Global Const $olIndentOriginalText = 3 ; OlActionResponseStyle Constants Global Const $olOpen = 0 Global Const $olSend = 1 Global Const $olPrompt = 2 ; OlActionShowOn Constants Global Const $olDontShow = 0 Global Const $olMenu = 1 Global Const $olMenuAndToolbar = 2 ; OlAttachmentType Constants Global Const $olByValue = 1 Global Const $olByReference = 4 Global Const $olEmbeddedItem = 5 Global Const $olOLE = 6 ; OlBusyStatus Constants Global Const $olFree = 0 Global Const $olTentative = 1 Global Const $olBusy = 2 Global Const $olOutOfOffice = 3 ; OlDaysOfWeek Global Const $olSunday =1 Global Const $olMonday =2 Global Const $olTuesday =4 Global Const $olWednesday =8 Global Const $olThursday =16 Global Const $olFriday =32 Global Const $olSaturday =64 ; OlDefaultFolders Constants Global Const $olFolderDeletedItems = 3 Global Const $olFolderOutbox = 4 Global Const $olFolderSentMail = 5 Global Const $olFolderInbox = 6 Global Const $olFolderCalendar = 9 Global Const $olFolderContacts = 10 Global Const $olFolderJournal = 11 Global Const $olFolderNotes = 12 Global Const $olFolderTasks = 13 ; OlFlagStatus Constants Global Const $olNoFlag = 0 Global Const $olFlagComplete = 1 Global Const $olFlagMarked = 2 ; OlFolderDisplayMode Constants Global Const $olFolderDisplayNormal = 0 Global Const $olFolderDisplayFolderOnly = 1 Global Const $olFolderDisplayNoNavigation = 2 ; OlFormRegistry Constants Global Const $olDefaultRegistry = 0 Global Const $olPersonalRegistry = 2 Global Const $olFolderRegistry = 3 Global Const $olOrganizationRegistry = 4 ; OlGender Constants Global Const $olUnspecified = 0 Global Const $olFemale = 1 Global Const $olMale = 2 ; OlImportance Constants Global Const $olImportanceLow = 0 Global Const $olImportanceNormal = 1 Global Const $olImportanceHigh = 2 ; OlInspectorClose Constants Global Const $olSave = 0 Global Const $olDiscard = 1 Global Const $olPromptForSave = 2 ; OlItems Constants Global Const $olMailItem = 0 Global Const $olAppointmentItem = 1 Global Const $olContactItem = 2 Global Const $olTaskItem = 3 Global Const $olJournalItem = 4 Global Const $olNoteItem = 5 Global Const $olPostItem = 6 ; OlJournalRecipientsType Constants Global Const $olAssociatedContact = 1 ; OlMailingAddress Constants Global Const $olNone = 0 Global Const $olHome = 1 Global Const $olBusiness = 2 Global Const $olOther = 3 ; OlMailRecipientType Constants Global Const $olOriginator = 0 Global Const $olTo = 1 Global Const $olCC = 2 Global Const $olBCC = 3 ; OlMeetingRecipientType Constants Global Const $olOrganizer = 0 Global Const $olRequired = 1 Global Const $olOptional = 2 Global Const $olResource = 3 ; OlMeetingResponse Constants Global Const $olMeetingTentative = 2 Global Const $olMeetingAccepted = 3 Global Const $olMeetingDeclined = 4 ; OlMeetingStatus Constants Global Const $olNonMeeting = 0 Global Const $olMeeting = 1 Global Const $olMeetingReceived = 3 Global Const $olMeetingCanceled = 5 ; OlNoteColor Constants Global Const $olBlue = 0 Global Const $olGreen = 1 Global Const $olPink = 2 Global Const $olYellow = 3 Global Const $olWhite = 4 ; OlRecurrenceType Constants Global Const $olRecursDaily = 0 Global Const $olRecursWeekly = 1 Global Const $olRecursMonthly = 2 Global Const $olRecursMonthNth = 3 Global Const $olRecursYearly = 5 Global Const $olRecursYearNth = 6 ; OlRemoteStatus Constants Global Const $olRemoteStatusNone = 0 Global Const $olUnMarked = 1 Global Const $olMarkedForDownload = 2 Global Const $olMarkedForCopy = 3 Global Const $olMarkedForDelete = 4 ; OlResponseStatus Constants Global Const $olResponseNone = 0 Global Const $olResponseOrganized = 1 Global Const $olResponseTentative = 2 Global Const $olResponseAccepted = 3 Global Const $olResponseDeclined = 4 Global Const $olResponseNotResponded = 5 ; OlSaveAsType Constants Global Const $olTXT = 0 Global Const $olRTF = 1 Global Const $olTemplate = 2 Global Const $olMSG = 3 Global Const $olDoc = 4 ; OlSensitivity Constants Global Const $olNormal = 0 Global Const $olPersonal = 1 Global Const $olPrivate = 2 Global Const $olConfidential = 3 ; OlTaskDelegationState Constants Global Const $olTaskNotDelegated = 0 Global Const $olTaskDelegationUnknown = 1 Global Const $olTaskDelegationAccepted = 2 Global Const $olTaskDelegationDeclined = 3 ; OlTaskOwnerShip Constants Global Const $olNewTask = 0 Global Const $olDelegatedTask = 1 Global Const $olOwnTask = 2 ; OlTaskRecipientType Constants Global Const $olUpdate = 1 Global Const $olFinalStatus = 2 ; OlTaskResponse Constants Global Const $olTaskSimple = 0 Global Const $olTaskAssign = 1 Global Const $olTaskAccept = 2 Global Const $olTaskDecline = 3 ; OlTaskStatus Constants Global Const $olTaskNotStarted = 0 Global Const $olTaskInProgress = 1 Global Const $olTaskComplete = 2 Global Const $olTaskWaiting = 3 Global Const $olTaskDeferred = 4 ; OlTrackingStatus Constants Global Const $olTrackingNone = 0 Global Const $olTrackingDelivered = 1 Global Const $olTrackingNotDelivered = 2 Global Const $olTrackingNotRead = 3 Global Const $olTrackingRecallFailure = 4 Global Const $olTrackingRecallSuccess = 5 Global Const $olTrackingRead = 6 Global Const $olTrackingReplied = 7 ; OlUserPropertyType Constants Global Const $olText = 1 Global Const $olNumber = 3 Global Const $olDateTime = 5 Global Const $olYesNo = 6 Global Const $olDuration = 7 Global Const $olKeywords = 11 Global Const $olPercent = 12 Global Const $olCurrency = 14 Global Const $olFormula = 18 Global Const $olCombination = 19 [font="Fixedsys"][list][*]All of my AutoIt Example Scripts[*]http://saneasylum.com[/list][/font] Link to comment Share on other sites More sharing options...
Shevilie Posted November 8, 2006 Share Posted November 8, 2006 Thx need em Start here if you are new Valuater's AutoIT 1-2-3Looking for an UDF - Look hereDo you need to do it twice - Autoit Link to comment Share on other sites More sharing options...
DaleHohm Posted November 8, 2006 Share Posted November 8, 2006 And in the spirit of "teaching them to fish"...Here is a method of generating these constants for other COM interfaces: Extract Enum Constants and create Au3 constants. Note: you may need to download and resister tlbinf32.dll -- instructions in base post.Using JerryD's version in reply 7, this command:CreateIncludeFile('Outlook.Application', "au3", 'Outlook.au3', True)Creates this:CODE;;Enumerated Constants for CoClass "Outlook.Application";Extracted from "C:\Program Files\Microsoft Office\OFFICE11\msoutl.olb";;OlActioncopyLikeConst $olReply = 0Const $olReplyAll = 1Const $olForward = 2Const $olReplyFolder = 3Const $olRespond = 4;OlActionReplyStyleConst $olOmitOriginalText = 0Const $olEmbedOriginalItem = 1Const $olIncludeOriginalText = 2Const $olIndentOriginalText = 3Const $olLinkOriginalItem = 4Const $olUserPreference = 5Const $olReplyTickOriginalText = 1000;OlActionResponseStyleConst $olOpen = 0Const $olSend = 1Const $olPrompt = 2;OlActionShowOnConst $olDontShow = 0Const $olMenu = 1Const $olMenuAndToolbar = 2;OlAttachmentTypeConst $olByValue = 1Const $olByReference = 4Const $olEmbeddeditem = 5Const $olOLE = 6;OlBusyStatusConst $olFree = 0Const $olTentative = 1Const $olBusy = 2Const $olOutOfOffice = 3;OlDaysOfWeekConst $olSunday = 1Const $olMonday = 2Const $olTuesday = 4Const $olWednesday = 8Const $olThursday = 16Const $olFriday = 32Const $olSaturday = 64;OlDefaultFoldersConst $olFolderDeletedItems = 3Const $olFolderOutbox = 4Const $olFolderSentMail = 5Const $olFolderInbox = 6Const $olFolderCalendar = 9Const $olFolderContacts = 10Const $olFolderJournal = 11Const $olFolderNotes = 12Const $olFolderTasks = 13Const $olFolderDrafts = 16Const $olPublicFoldersAllPublicFolders = 18Const $olFolderConflicts = 19Const $olFolderSyncIssues = 20Const $olFolderLocalFailures = 21Const $olFolderServerFailures = 22Const $olFolderJunk = 23;OlDisplayTypeConst $olUser = 0Const $olDistList = 1Const $olForum = 2Const $olAgent = 3Const $olOrganization = 4Const $olPrivateDistList = 5Const $olRemoteUser = 6;OlEditorTypeConst $olEditorText = 1Const $olEditorHTML = 2Const $olEditorRTF = 3Const $olEditorWord = 4;OlFlagStatusConst $olNoFlag = 0Const $olFlagComplete = 1Const $olFlagMarked = 2;OlFolderDisplayModeConst $olFolderDisplayNormal = 0Const $olFolderDisplayFolderOnly = 1Const $olFolderDisplayNoNavigation = 2;OlFormRegistryConst $olDefaultRegistry = 0Const $olPersonalRegistry = 2Const $olFolderRegistry = 3Const $olOrganizationRegistry = 4;OlGenderConst $olUnspecified = 0Const $olFemale = 1Const $olMale = 2;OlImportanceConst $olImportanceLow = 0Const $olImportanceNormal = 1Const $olImportanceHigh = 2;OlInspectorCloseConst $olSave = 0Const $olDiscard = 1Const $olPromptForSave = 2;OlItemTypeConst $olMailItem = 0Const $olAppointmentItem = 1Const $olContactItem = 2Const $olTaskItem = 3Const $olJournalItem = 4Const $olNoteItem = 5Const $olPostItem = 6Const $olDistributionListItem = 7;OlJournalRecipientTypeConst $olAssociatedContact = 1;OlMailingAddressConst $olNone = 0Const $olHome = 1Const $olBusiness = 2Const $olOther = 3;OlMailRecipientTypeConst $olOriginator = 0Const $olTo = 1Const $olCC = 2Const $olBCC = 3;OlMeetingRecipientTypeConst $olOrganizer = 0Const $olRequired = 1Const $olOptional = 2Const $olResource = 3;OlMeetingResponseConst $olMeetingTentative = 2Const $olMeetingAccepted = 3Const $olMeetingDeclined = 4;OlMeetingStatusConst $olNonMeeting = 0Const $olMeeting = 1Const $olMeetingReceived = 3Const $olMeetingCanceled = 5;OlNetMeetingTypeConst $olNetMeeting = 0Const $olNetShow = 1Const $olExchangeConferencing = 2;OlNoteColorConst $olBlue = 0Const $olGreen = 1Const $olPink = 2Const $olYellow = 3Const $olWhite = 4;OlObjectClassConst $olApplication = 0Const $olNamespace = 1Const $olFolder = 2Const $olRecipient = 4Const $olAttachment = 5Const $olAddressList = 7Const $olAddressEntry = 8Const $olFolders = 15Const $olItems = 16Const $olRecipients = 17Const $olAttachments = 18Const $olAddressLists = 20Const $olAddressEntries = 21Const $olAppointment = 26Const $olMeetingRequest = 53Const $olMeetingCancellation = 54Const $olMeetingResponseNegative = 55Const $olMeetingResponsePositive = 56Const $olMeetingResponseTentative = 57Const $olRecurrencePattern = 28Const $olExceptions = 29Const $olException = 30Const $olAction = 32Const $olActions = 33Const $olExplorer = 34Const $olInspector = 35Const $olPages = 36Const $olFormDescription = 37Const $olUserProperties = 38Const $olUserProperty = 39Const $olContact = 40Const $olDocument = 41Const $olJournal = 42Const $olMail = 43Const $olNote = 44Const $olPost = 45Const $olReport = 46Const $olRemote = 47Const $olTask = 48Const $olTaskRequest = 49Const $olTaskRequestUpdate = 50Const $olTaskRequestAccept = 51Const $olTaskRequestDecline = 52Const $olExplorers = 60Const $olInspectors = 61Const $olPanes = 62Const $olOutlookBarPane = 63Const $olOutlookBarStorage = 64Const $olOutlookBarGroups = 65Const $olOutlookBarGroup = 66Const $olOutlookBarShortcuts = 67Const $olOutlookBarShortcut = 68Const $olDistributionList = 69Const $olPropertyPageSite = 70Const $olPropertyPages = 71Const $olSyncObject = 72Const $olSyncObjects = 73Const $olSelection = 74Const $olLink = 75Const $olLinks = 76Const $olSearch = 77Const $olResults = 78Const $olViews = 79Const $olView = 80Const $olItemProperties = 98Const $olItemProperty = 99Const $olReminders = 100Const $olReminder = 101Const $olConflict = 102Const $olConflicts = 103;OlOutlookBarViewTypeConst $olLargeIcon = 0Const $olSmallIcon = 1;OlPaneConst $olOutlookBar = 1Const $olFolderList = 2Const $olPreview = 3Const $olNavigationPane = 4;OlRecurrenceStateConst $olApptNotRecurring = 0Const $olApptMaster = 1Const $olApptOccurrence = 2Const $olApptException = 3;OlRecurrenceTypeConst $olRecursDaily = 0Const $olRecursWeekly = 1Const $olRecursMonthly = 2Const $olRecursMonthNth = 3Const $olRecursYearly = 5Const $olRecursYearNth = 6;OlRemoteStatusConst $olRemoteStatusNone = 0Const $olUnMarked = 1Const $olMarkedForDownload = 2Const $olMarkedForCopy = 3Const $olMarkedForDelete = 4;OlResponseStatusConst $olResponseNone = 0Const $olResponseOrganized = 1Const $olResponseTentative = 2Const $olResponseAccepted = 3Const $olResponseDeclined = 4Const $olResponseNotResponded = 5;OlSaveAsTypeConst $olTXT = 0Const $olRTF = 1Const $olTemplate = 2Const $olMSG = 3Const $olDoc = 4Const $olHTML = 5Const $olVCard = 6Const $olVCal = 7Const $olICal = 8Const $olMSGUnicode = 9;OlSensitivityConst $olNormal = 0Const $olPersonal = 1Const $olPrivate = 2Const $olConfidential = 3;OlSortOrderConst $olSortNone = 0Const $olAscending = 1Const $olDescending = 2;OlTaskDelegationStateConst $olTaskNotDelegated = 0Const $olTaskDelegationUnknown = 1Const $olTaskDelegationAccepted = 2Const $olTaskDelegationDeclined = 3;OlTaskOwnershipConst $olNewTask = 0Const $olDelegatedTask = 1Const $olOwnTask = 2;OlTaskRecipientTypeConst $olUpdate = 2Const $olFinalStatus = 3;OlTaskResponseConst $olTaskSimple = 0Const $olTaskAssign = 1Const $olTaskAccept = 2Const $olTaskDecline = 3;OlTaskStatusConst $olTaskNotStarted = 0Const $olTaskInProgress = 1Const $olTaskComplete = 2Const $olTaskWaiting = 3Const $olTaskDeferred = 4;OlTrackingStatusConst $olTrackingNone = 0Const $olTrackingDelivered = 1Const $olTrackingNotDelivered = 2Const $olTrackingNotRead = 3Const $olTrackingRecallFailure = 4Const $olTrackingRecallSuccess = 5Const $olTrackingRead = 6Const $olTrackingReplied = 7;OlUserPropertyTypeConst $olOutlookInternal = 0Const $olText = 1Const $olNumber = 3Const $olDateTime = 5Const $olYesNo = 6Const $olDuration = 7Const $olKeywords = 11Const $olPercent = 12Const $olCurrency = 14Const $olFormula = 18Const $olCombination = 19;OlWindowStateConst $olMaximized = 0Const $olMinimized = 1Const $olNormalWindow = 2;OlSyncStateConst $olSyncStopped = 0Const $olSyncStarted = 1;OlBodyFormatConst $olFormatUnspecified = 0Const $olFormatPlain = 1Const $olFormatHTML = 2Const $olFormatRichText = 3;OlDownloadStateConst $olHeaderOnly = 0Const $olFullItem = 1;OlOfficeDocItemsTypeConst $olExcelWorkSheetItem = 8Const $olWordDocumentItem = 9Const $olPowerPointShowItem = 10;OlViewSaveOptionConst $olViewSaveOptionThisFolderEveryone = 0Const $olViewSaveOptionThisFolderOnlyMe = 1Const $olViewSaveOptionAllFoldersOfType = 2;OlViewTypeConst $olTableView = 0Const $olCardView = 1Const $olCalendarView = 2Const $olIconView = 3Const $olTimelineView = 4;OlFlagIconConst $olNoFlagIcon = 0Const $olPurpleFlagIcon = 1Const $olOrangeFlagIcon = 2Const $olGreenFlagIcon = 3Const $olYellowFlagIcon = 4Const $olBlueFlagIcon = 5Const $olRedFlagIcon = 6;OlExchangeConnectionModeConst $olNoExchange = 0Const $olOffline = 100Const $olCachedOffline = 200Const $olDisconnected = 300Const $olCachedDisconnected = 400Const $olCachedConnectedHeaders = 500Const $olCachedConnectedDrizzle = 600Const $olCachedConnectedFull = 700Const $olOnline = 800;OlShowItemCountConst $olNoItemCount = 0Const $olShowUnreadItemCount = 1Const $olShowTotalItemCount = 2;OlStoreTypeConst $olStoreDefault = 1Const $olStoreUnicode = 2Const $olStoreANSI = 3;OlPermissionConst $olUnrestricted = 0Const $olDoNotForward = 1Const $olPermissionTemplate = 2;OlPermissionServiceConst $olUnknown = 0Const $olWindows = 1Const $olPassport = 2Dale Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model Automate input type=file (Related) Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded Better Better? IE.au3 issues with Vista - Workarounds SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead? Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble Link to comment Share on other sites More sharing options...
lod3n Posted November 9, 2006 Author Share Posted November 9, 2006 Okay, that's freaking cool... [font="Fixedsys"][list][*]All of my AutoIt Example Scripts[*]http://saneasylum.com[/list][/font] Link to comment Share on other sites More sharing options...
makogen Posted April 27, 2008 Share Posted April 27, 2008 omg i love u so much!!! TYYY I've been trying to figure out the Outlook Com file on my own...using ExcelCom.au3 and IE.au3 and comparing them to the COM objects from the MSDN site. I've learned a lot about COM, but couldn't figure out how to use it with outlook. There's not much I could find. This helps soooo much. Just so I know because I'll go crazy if I don't ask, are all of the types for say createItem(), are they all numerical? or is the number given in the cons definition just the order in which they're listed? How does it work? I'm sorry I'm so noob, but it's my first time working with COM ever, and it's been pretty nerve wracking... Link to comment Share on other sites More sharing options...
VB6Rules Posted April 28, 2008 Share Posted April 28, 2008 This should be a default include! Imagine: #include <OutlookConstamts.au3> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now