Skysnake Posted May 28, 2021 Posted May 28, 2021 @water another question. Create a new email message with text including markup. Have you ever tried that? My body gets inserted, but all html gets stripped/converted to plain text. Any examples I could look at? Skysnake Why is the snake in the sky?
water Posted May 28, 2021 Author Posted May 28, 2021 My UDFs only work with the on premise versions of Microsoft programs. The cloud versions use a completely different interface so my UDFs will become useless when you move to the cloud. Seems to be an old example as CommandBars have been replaced with Ribbons. Please see: https://docs.microsoft.com/en-sg/office/vba/outlook/how-to/office-fluent-ui-extensibility/updating-earlier-code-for-commandbars When you follow the links you'll see that implementing the Ribbon interface can become quite tricky. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Skysnake Posted June 9, 2021 Posted June 9, 2021 As far as .Net is concerned, I do not think you need to worry. Looks like online and .Net will find each other somehow https://www.c-sharpcorner.com/article/future-of-dot-net/ As far as the command bar question is concerned. My attempt is focussed on the individual inspectors, not the actual menu bar. Skysnake Why is the snake in the sky?
water Posted June 9, 2021 Author Posted June 9, 2021 8 minutes ago, Skysnake said: As far as the command bar question is concerned. My attempt is focussed on the individual inspectors, not the actual menu bar. But the example you posted uses CommandBars. What do you try to achieve? Adding the button is just a small part of the story. You need to run some code when the user clicks the button. What have you tried so far? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
water Posted June 9, 2021 Author Posted June 9, 2021 On 5/28/2021 at 8:02 PM, Skysnake said: Create a new email message with text including markup. How do you create the mail item and how to do you add the text/markup? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
HighlanderSword Posted July 8, 2021 Posted July 8, 2021 Hello, I've turned on error logging to file. Below is an example of an error in the log When I google the NumberHex value I get a lot of hits on Registry issues How do I identify what is causing the issue , Scriptline 367 is a blank line in my script COM Error Encountered in debug.au3 UDF version = OutlookEX_Base: 1.2.3.0 2020-12-10 OutlookEX: 1.6.3.1 2020-12-15 @AutoItVersion = 3.3.14.5 @AutoItX64 = 1 @Compiled = 0 @OSArch = X64 @OSVersion = WIN_10 Scriptline = 367 NumberHex = 0x80020009 Number = -2147352567 WinDescription = Exception occurred. Description = Source = HelpFile = HelpContext = 0 LastDllError = 0
water Posted July 8, 2021 Author Posted July 8, 2021 0x80020009 is a general error As line 367 is a comment line in OutlookE.au3 and OutlookEX_Base.au3 we need to see your script before we can give further advice. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Nicolas57 Posted July 9, 2021 Posted July 9, 2021 (edited) Hi community As suggested, I relate my problem here and allready found 50% of my solutions browsing the whole thread 1° I needed to send an email with a different email addresse than my personnal one, in such case a mail box with delegation The solution seems to use Local $oOutlook = _OL_Open ( ) Local $oMail = _OL_ItemCreate ( $oOutlook, $olMailItem, "", "", "Subject=" & $Object ) $oMail.BodyFormat = $olFormatHTML $oMail.GetInspector $Signature = $oMail.HTMLBody $oMail.HTMLBody = "test" & $Signature $oMail.To = $Dest $oMail.SentOnBehalfOfName = "it-group@domain.fr" _OL_ItemSend ( $oOutlook, $oMail ) 2° I'd like to pick all delegation mail box to allow the user to select which one will be used to send an email I used _OL_StoreGet ( $oOutlook ) that did the job, but I got an alias fro delegation boxes instead of an email address How is it possible please to get the email address of each alias ? Or, is there a way to sent a mail using alias ( Did a try and it fails ) Here's content of _OL_StoreGet ( $oOutlook ) Regards Edited July 9, 2021 by Nicolas57
water Posted July 12, 2021 Author Posted July 12, 2021 What you get from _OL_StoreGet in Col 0 are the displaynames of the mailboxes. Could you please try _OL_AccountGet? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Skysnake Posted July 13, 2021 Posted July 13, 2021 @HighlanderSword How do I identify what is causing the issue , Scriptline 367 is a blank line in my script Bear in mind that any includes will appear first, followed by your code. This means that line 367 is the final, running script, not necessarily the code you wrote. Can you simplify and reproduce? Obviously something is causing this, we just need to know where to look Skysnake Why is the snake in the sky?
Skysnake Posted July 13, 2021 Posted July 13, 2021 @Nicolas57 see here? Ending 11 April. This worked for me. Skysnake Why is the snake in the sky?
noellarkin Posted August 21, 2021 Posted August 21, 2021 (edited) @water thank you so much for this UDF, I've used it to automate sorting operations and taks creation in my on-premise installation of Outlook. I was wondering if I could get your advice on something: I've been trying to find a function in the UDF that would trigger Outlook to receive new e-mails from my POP3 accounts that have been added as PST files. Currently, all my functions can sort, perform RegExp searches etc on mails that have been downloaded already, but I have to wait for Outlook to do its scheduled send/receive to retreive new mails from the mailserver. Is there any function in your UDF (or another) that can trigger a fresh send/receive command? Thanks again. EDIT: I'm such a dumbass I missed the _OL_Sync function :) Anyway, the script's working perfectly now :) Edited August 21, 2021 by noellarkin stupidly missed _OL_Sync
water Posted August 21, 2021 Author Posted August 21, 2021 According to this book (for Outlook 2007) Events only get raised for the default Store: https://books.google.at/books?id=DnxuBDWM9E4C&pg=PT628&lpg=PT628&dq=outlook+newmail+event+pst&source=bl&ots=-KtR7m1OOe&sig=ACfU3U1ADmVjwghXFcXGMGrJa_V9gz21Aw&hl=de&sa=X&ved=2ahUKEwiH6bHRxMHyAhX3gf0HHeCPBiMQ6AF6BAgXEAM#v=onepage&q=outlook newmail event pst&f=false But I'm not sure this is still true. Maybe this sheds some light onto the subject: https://docs.microsoft.com/en-za/office/vba/api/outlook.application.newmailex I think it should work with PST as with any other folder. Did you test the NewMailEX example script provided with the UDF? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
noellarkin Posted August 22, 2021 Posted August 22, 2021 @water thanks for getting back to me - - I tried _OL_Sync() which got the job done - - you're saying the NewMailEX function does the exact same thing?
water Posted August 22, 2021 Author Posted August 22, 2021 I misinterpreted your question. After re-reading I understand that _OL_Sync is the best solution My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Andrue Posted September 9, 2021 Posted September 9, 2021 (edited) Hi, Are there any who can help me with: select the oldest mails first. and script not always printer. I have made a script that uses OutlookEX UDF. To look in an Outlook folder for mails, when it finds one, it checks if the email contains any attachments. as it stores a folder. Then it sorts the files, based on an array of file types (.pdf, .doc, .docx, and print those files. Are there any of you who can explain to me why my script does not always print. whether one can make a check for print And how can I get it to always select the oldest mails first? I do not know if I am using some of the features incorrectly. but it seems to work some of the time. Edited September 9, 2021 by Melba23 Merged posts
Moderators Melba23 Posted September 9, 2021 Moderators Posted September 9, 2021 Andrue, Welcome to the AutoIt forums. But in future, please stick to just the one thread. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area
Andrue Posted September 10, 2021 Posted September 10, 2021 Thanks and sorry. Here is my code. Hope can help me. Print Outlook attachments1.5.au3
Skysnake Posted September 10, 2021 Posted September 10, 2021 @Andrue can you perhaps explain the "print" part? How do you print those attachments manually, and how do you expect AutoIt to do it? (its a long script) Skysnake Why is the snake in the sky?
seadoggie01 Posted September 10, 2021 Posted September 10, 2021 On 9/9/2021 at 3:16 PM, Andrue said: Are there any of you who can explain to me why my script does not always print. whether one can make a check for print Your code is a bit difficult to follow, maybe take a look at some of the coding practices we use, but this is understandable if you're new One reason could be that you're using _ArrayBinarySearch, which requires that the array is sorted beforehand. I'd suggest using _ArraySearch instead. Also, it's vital that you check @error values immediately after calling a function. If you call any other function, the value will be reset. All my code provided is Public Domain... but it may not work. Use it, change it, break it, whatever you want. Spoiler My Humble Contributions:Personal Function Documentation - A personal HelpFile for your functionsAcro.au3 UDF - Automating Acrobat ProToDo Finder - Find #ToDo: lines in your scriptsUI-SimpleWrappers UDF - Use UI Automation more Simply-erKeePass UDF - Automate KeePass, a password managerInputBoxes - Simple Input boxes for various variable types
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