We are receiving email that contains Image based . We need to extract the data like Order ID, Item Code etc from the email body I’m using Get IMap Mail message activity and with for each we are extracting the email, based on the subject. Like below,
“Men’s Wearhouse(R) Your Complete Order Has Shipped! Hi, JOHN. The following item(s) have shipped. To make a return, please bring the item(s) along with this email to your nearest store. Order Number 010923251253759000203 Order Placed 9/23/2025 Item(s) Shipped 1 items Shipping to: JOHN SMITH 7131 CONGO RD THEODORE AL 36582-6202 FedEx Tracking Number Track My Package product image JA EGY 100S SLD TWILL MODERN SPREAD NEW NATURAL ST Qty: 1 • Color: BLUE • Size: 15 1/2 34/35 • Sku: #TMW59T055551 Return Policy If you are not completely satisfied, you may return or exchange your purchase within 90 days from the original date of purchase. Returns after 90 days are eligible to receive an in-store credit only. To make a return, simply bring this email to your nearest store .”
But I’m not getting the values which is present in email instead I’m just getting the below tags ,
“@“Mens Wearhouse /* GOOGLE fonts ------------------------/ @import url("“https://fonts.googleapis.com/css?family=Roboto+Condensed:300,400,500,600,700,800|Oswald:400,600,700|Roboto: 300,500,600,700|Open+Sans:300,500,600,700"”); / Note that inline font family declarations place google font at end as not to break outlook. This style reorders google font to first pick for clients that support (outlook will ignore this) / [style=”“Roboto””] { font-family: ““Roboto””, Arial, sans-serif !important; } [style*=““Roboto Condensed””] { font-family: ““Roboto Condensed””, Arial, sans-serif !important; } [style*=““Oswald””] { font-family: ““Oswald””, Arial, sans-serif !important; } [style*=““Open Sans””] { font-family: ““Open Sans””, Arial, sans-serif !important; } html { -webkit-text-size-adjust: none; } .hotmail-fix div, .hotmail-fix div button { display: block !important; } /* RESPONSIVE ------------------------/ @media screen and (max-width: 601px) { / MOBILE TEXT ------------------------/ .mobile-text-sm { font-size: 11px !important; line-height: 15px !important; } } / text smoothing for more consistent font rendering */ body { -webkit-font-smoothing: antialiased; -moz-osx-font-smoothing: grayscale; text-rendering: optimizeLegibility; } (https://www.menswearhouse.com?utm_content=Header-MW-Logo-1.1-null) nearest store. nearest store . (http://l.tx.menswearhouse.com/rts/go2.aspx?t=15014914&tp=i-1NGB-JM-QRL-RvIHLg-2N-QM5S-1c-QXMIwc-lCMRHOSR6L-1E5E6r&pi=k-qRdAZWKqUY13JnxQgumPb9zNbCIyV9YH8gO8GTXvg&x=|TRG|Omni_Sale_Shipping_Confirmation_Email-Full_Shipping|8c37f2ce48164ee025a9536e68847cd7fa765333621262d3ce063c816fb0eaa3|i-1NGB-JM-QRL-RvIHLg-2N-QM5S-1c-QXMIwc-lCMRHOSR6L-1E5E6r&hp2=bbf80121f5f0cd475b28937db7904bf912f76df5ef5967dd4b5a0569e02c1ff5)“” style=““display:inline-block;-webkit-text-size-adjust:none;mso-hide:all;font-family: sans-serif;font-size: 12px;font-weight: 700;line-height: 40px;width: 182px;background-color: #002749;color: #FFFFFF;border: none;text-decoration: none;text-align: center;CONTACT US This email was automatically generated. Please do not reply. If you have any comments or questions, please (https://www.menswearhouse.com/slc/contact-us?utm_content=Footer-3up-store-1.7-evergreen)”” style=““color: #000000;contact us. (http://x.tx.menswearhouse.com/ats/msg.aspx?sg1=65f8f79c198034b70f4afdd213075a21bfe66d3b7602f1ffce19c644b55e0e59)”” style="“color: #ffffff; font-family: Arial,Helvetica, sans-serif; font-size: 10px; text-align: left; text-decoration: underline;. " .”
I’ve tried to extract with Regex with Currentmailmessage.body by using the Cleanbody=System.Text.RegularExpressions.Regex.Replace(currentMailMessage.Body, “<.*?>”, String.Empty) and cleanBody.Replace(“\r”, “”).Replace(“\n”, Environment.NewLine).
Also I’ve tried to use Extract text activity . since when I’m getting the value as direct above error value we are not able convert this. Can you suggest me a solution for this .
