Tôi đã có thể tìm ra cách xem toàn bộ mã HTML của email từ Outlook trên máy tính để bàn. Các trường mà tôi cần trích xuất nhưng Power Query (với các thẻ RGB màu đỏ mà tôi đặt bên cạnh chẳng hạn như các trường Vị trí, Giao hàng đến, Được sắp xếp theo thứ tự, v.v.) không đọc nội dung email, chỉ một phần mã mà tôi đã hiển thị trong Bài đăng
HTML <!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><style type="text/css">
table.gridTable {
font-family: Arial, Helvetica, sans-serif;
font-size:13px;
border: 2px solid black;
border-collapse: collapse;
}
table.gridTable td, th {
border: 2px solid black;
padding: 8px;
}
tr.noBorder td{ border-top: 0px; border-bottom:0px; padding: 8px;}
td.label { font-weight:bold; width:160px;}
td.label2{ font-weight:bold; width:250px;}
.infoTable{border-style:none;border-collapse: collapse;}
.infoTable td{border-style:none;padding:1px 0px;}
.notificationUrlLink{
font-family: Arial, Helvetica, sans-serif;
font-size:27px;
text-decoration:underline;
color: #3089C5;
font-weight: bold;
}
.notificationUrlLinkDiv{
margin-top: 15px;margin-bottom: 15px;
}
</style>
</head>
<body>
<div style="margin-left:35px;margin-right:35px;">
<div style="width: 70%;margin:auto;font-style: italic; color:#717173">To ensure delivery of McDonalds emails to your inbox, please add
<a href="mailto:[email protected]">[email protected]</a> to your Email Address Book or Safe Senders List.<br>
If you no longer wish to receive email notification when you place an order through mcdonalds.com, simply go to your profile settings and unselect the "Notify me when any order status changes" option.'
</div>
<div style="margin-top: 35px;margin-bottom: 35px;"><img src="http://www1.mcdonalds.com/order/images/logos/logo_login_usf.jpg">
</div>
<!-- Link in email -->
<div class="notificationUrlLinkDiv"><a class="notificationUrlLink" href="https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww3.usfoods.com%2Forder%2Ffaces%2Fpub%2Fsec%2FecPortal.jspx%3FORDER_ID%3DK67447TK869A5020W88Y&data=05%7C01%7C%7Cbd9f125005eb49d1350b08da96bcc373%7Ce95f1b23abaf45ee821db7ab251ab3bf%7C0%7C0%7C637988034729095203%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=xbr0yaJZudmEBK3THEH22s99Qf%2Fx8r2kqb%2FdgncU7D4%3D&reserved=0" originalsrc="https://www3.mcdonalds.com/order/faces/pub/sec/ecPortal.jspx?ORDER_ID=K67447TK869A5020W88Y" shash="mDlqO4KzDTDtZzJpHfvp3gX+sm3I/sXyR1MxqeJzFYbhIBaMfOBpKlyTmFj6NWsiUL5nG6gVQYLd1P1jHItxhMJltghrR5y/Jvs/hgIQBpac4Fmb/XMK6DYr3QGV6SjBeKDz1ptPp3Ibbp3OV7cTdejA0MAg7VkBu17nlU4CAiM=">View My Order</a>
</div>
<div style="color: #CE4620;font-size: 24px;font-weight: bold;font-style: italic;margin-bottom: 20px;">
Order Submitted</div>
<div id="emailBody">
<p>Thank you for your recent order placed with mcdonalds.com. This email notice was sent to you based on your preferences settings with mcdonalds.com whenever an order is placed for this customer:
</p>
<table class="infoTable">
<tbody>
<tr>
<td class="label"><b>Details of your order:</b></td>
<td> </td>
</tr>
<tr>
<td>[COLOR=rgb(184, 49, 47)]Location:[/COLOR]</td>
<td>MCDC #301Los Angeles (33495720)</td>
</tr>
<tr>
<td>Department:</td>
<td>DIETARY (10)</td>
</tr>
<tr>
<td>[COLOR=rgb(184, 49, 47)]Ship To[/COLOR]:</td>
<td>2100 Sunset Blvd<br>
(120-PAD)<br>
Los Angeles, CA 9020100000 </td>
</tr>
<tr>
<td>[COLOR=rgb(184, 49, 47)]Ordered By:[/COLOR]</td>
<td>Joe Smith</td>
</tr>
<tr>
<td>Special Instructions:</td>
<td>NA CUSTOMER. DRIVER PLEASE CALL 30 MIN BEFORE DELIVERY TO MINIMIZE DELAY.</td>
</tr>
<tr>
<td>[COLOR=rgb(184, 49, 47)]Delivery Date:[/COLOR]</td>
<td>04/1/2020</td>
</tr>
<tr>
<td>[COLOR=rgb(184, 49, 47)]Order Number:[/COLOR]</td>
<td>375500</td>
</tr>
<tr>
<td>Customer PO#:</td>
<td>C20010-91422</td>
</tr>
<tr>
<td>Order Guide:</td>
<td>374976</td>
</tr>
<tr>
<td>Order Status:</td>
<td>Submitted</td>
</tr>
<tr>
<td>Requested Delivery Date:</td>
<td>09/16/2022</td>
</tr>
</tbody>
</table>
<br>
| 
