ElRojo Posted July 10, 2020 Share Posted July 10, 2020 (edited) Water maybe you can strike again whit these one! Thank you so much for your contributions!! We have a lot of questions ! Trying to visualize the body.. #include <OutlookEX.au3> Global $aAttachments ; Connect to Outlook Global $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error opening connection to Outlook. @error = " & @error & ", @extended = " & @extended) ; Access the Inbox Global $aFolder = _OL_FolderAccess($oOutlook, "", $olFolderInbox) If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error accessing the Inbox. @error = " & @error & ", @extended = " & @extended) ;Leer arbol de carpetas Global $iLevel = 9999 Global $nTreeF =_OL_FolderTree($oOutlook, $aFolder[1],$iLevel) Global $nItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "[UnRead]=True", "", "", "EntryID,Subject,SenderEmailAddress", "", 4) Global $busqueda = "RV: Emision de comprobante virtual" Global $aSearchArray[2][4] = [[1, 4],[0x0037001E, 1, $busqueda]] ; Search for unread items with attachments ;Global $sFilter = "@SQL=""urn:schemas:httpmail:hasattachment"" = 1 and ""urn:schemas:httpmail:read""=0" Global $sFilter = "@SQL=""urn:schemas:httpmail:read""=0" Global $aResult = _OL_ItemSearch($oOutlook, $aFolder[1], $sFilter, "EntryID,subject,SenderEmailAddress") ;Global $aResult = _OL_ItemSearch($oOutlook, $aFolder[1], $aSearchArray, "EntryID,subject,urn:schemas:httpmail:textdescription,SenderEmailAddress") ; Find all items in the inbox ;Global $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "", "", $olDistributionList, "", 1) ;Global $oItem = $oOutlook.Session.GetItemFromID($aItems[1][0], Default) ; retrieve the items object ;$sBody = $oItem.Body If @error Then MsgBox(16, "OutlookEX UDF - _OL_ItemSearch Example Script", "Error running _OL_ItemSearch. @error = " & @error & ", @extended = " & @extended) Else _ArrayDisplay($nTreeF, "Outlook Informacion de arbol desde el folder" & $nItems) _Arraydisplay($aResult, "Example 6") ;_Arraydisplay($aItems, "Body") EndIf Edited July 10, 2020 by ElRojo Link to comment Share on other sites More sharing options...
ElRojo Posted July 10, 2020 Author Share Posted July 10, 2020 We also try these one of Water Our goal is to obtain the body of an email and save it in a file where you can use itExcel for example #include <Outlook.au3> ;verificacion del total de mails sin leer $oOutlook = _OutlookOpen() $eR = _OutlookGetMail($oOutlook, $olFolderInbox, False, "", "", "", "", "", "", True, "", 0, True) MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & $eR[1][9] & " of them are unread") _Arraydisplay($eR, "correos") William Programador: MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & $eR[1][9] & " of them are unread") MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & ^ ERROR Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted July 10, 2020 Moderators Share Posted July 10, 2020 (edited) Moved to the appropriate forum, as the Developer General Discussion forum very clearly states: Quote General development and scripting discussions. Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums. Moderation Team Edited July 10, 2020 by JLogan3o13 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
ElRojo Posted July 10, 2020 Author Share Posted July 10, 2020 Water maybe you can strike again whit these one! Thank you so much for your contributions!! We have a lot of questions ! Trying to visualize the body.. #include <OutlookEX.au3> Global $aAttachments ; Connect to Outlook Global $oOutlook = _OL_Open() If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error opening connection to Outlook. @error = " & @error & ", @extended = " & @extended) ; Access the Inbox Global $aFolder = _OL_FolderAccess($oOutlook, "", $olFolderInbox) If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error accessing the Inbox. @error = " & @error & ", @extended = " & @extended) ;Leer arbol de carpetas Global $iLevel = 9999 Global $nTreeF =_OL_FolderTree($oOutlook, $aFolder[1],$iLevel) Global $nItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "[UnRead]=True", "", "", "EntryID,Subject,SenderEmailAddress", "", 4) Global $busqueda = "RV: Emision de comprobante virtual" Global $aSearchArray[2][4] = [[1, 4],[0x0037001E, 1, $busqueda]] ; Search for unread items with attachments ;Global $sFilter = "@SQL=""urn:schemas:httpmail:hasattachment"" = 1 and ""urn:schemas:httpmail:read""=0" Global $sFilter = "@SQL=""urn:schemas:httpmail:read""=0" Global $aResult = _OL_ItemSearch($oOutlook, $aFolder[1], $sFilter, "EntryID,subject,SenderEmailAddress") ;Global $aResult = _OL_ItemSearch($oOutlook, $aFolder[1], $aSearchArray, "EntryID,subject,urn:schemas:httpmail:textdescription,SenderEmailAddress") ; Find all items in the inbox ;Global $aItems = _OL_ItemFind($oOutlook, $aFolder[1], $olMail, "", "", "", $olDistributionList, "", 1) ;Global $oItem = $oOutlook.Session.GetItemFromID($aItems[1][0], Default) ; retrieve the items object ;$sBody = $oItem.Body If @error Then MsgBox(16, "OutlookEX UDF - _OL_ItemSearch Example Script", "Error running _OL_ItemSearch. @error = " & @error & ", @extended = " & @extended) Else _ArrayDisplay($nTreeF, "Outlook Informacion de arbol desde el folder" & $nItems) _Arraydisplay($aResult, "Example 6") ;_Arraydisplay($aItems, "Body") EndIf Edited 5 hours ago by ElRojo Quote Edit ElRojo Seeker Members 0 5 posts Report post Posted 5 hours ago We also try these one of Water Our goal is to obtain the body of an email and save it in a file where you can use itExcel for example #include <Outlook.au3> ;verificacion del total de mails sin leer $oOutlook = _OutlookOpen() $eR = _OutlookGetMail($oOutlook, $olFolderInbox, False, "", "", "", "", "", "", True, "", 0, True) MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & $eR[1][9] & " of them are unread") _Arraydisplay($eR, "correos") William Programador: MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & $eR[1][9] & " of them are unread") MsgBox(0, '', "You have a total of " & $eR[0][0] & " mails in your inbox. " & ^ ERROR Link to comment Share on other sites More sharing options...
ElRojo Posted July 10, 2020 Author Share Posted July 10, 2020 Sorry! Link to comment Share on other sites More sharing options...
water Posted July 11, 2020 Share Posted July 11, 2020 What kind of problems do you encounter? Do you get an error when calling a _OL_* function? Do you get no body or a truncated body? Please explain in detail what your problem is. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki 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