cheesestain Posted May 30, 2018 Share Posted May 30, 2018 I'm having a problem with the way _OL_ItemFind is storing the body of an email in the array. When I view the part of the array that contains the body of the email on my computer it shows URL's as <http://url>. However, when my coworker is using the same script the array displays the same email with URL as: HYPERLINK "http://url" This is how i'm using _OL_ItemFind Global $dItems = _OL_ItemFind($oOutlook, $Mailbox, $olMail, "", "Subject", "NonEMM", "Subject,Body,EntryID,ReceivedTime", "[ReceivedTime]") Global $dlink = _StringBetween($dItems[1][1], ".txt <", ">") Link to comment Share on other sites More sharing options...
water Posted May 30, 2018 Share Posted May 30, 2018 What's the format of the mail item: Text, HTML or RTF? 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...
cheesestain Posted May 30, 2018 Author Share Posted May 30, 2018 I checked on both my computer and my coworkers. When the email is opened in outlook the title of the window has (HTML). Also the URL in the body has a clickable hyperlink. Link to comment Share on other sites More sharing options...
water Posted May 30, 2018 Share Posted May 30, 2018 Do you run the same version of Outlook? Do you run the same version of WIndows? 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...
cheesestain Posted May 30, 2018 Author Share Posted May 30, 2018 I'd have to double check, but at a glance it does appear that we both have Windows 7 with Outlook 2013. Link to comment Share on other sites More sharing options...
water Posted May 30, 2018 Share Posted May 30, 2018 When the format is HTML then you should retrieve the HTMLBody property: https://msdn.microsoft.com/en-us/VBA/Outlook-VBA/articles/mailitem-htmlbody-property-outlook 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