cheesestain Posted May 30, 2018 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 <", ">")
water Posted May 30, 2018 Posted May 30, 2018 What's the format of the mail item: Text, HTML or RTF? My UDFs and Tutorials: Reveal hidden contents 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
cheesestain Posted May 30, 2018 Author 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.
water Posted May 30, 2018 Posted May 30, 2018 Do you run the same version of Outlook? Do you run the same version of WIndows? My UDFs and Tutorials: Reveal hidden contents 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
cheesestain Posted May 30, 2018 Author 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.
water Posted May 30, 2018 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: Reveal hidden contents 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
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