tommy8quko
New Member
- Joined
- Mar 27, 2017
- Messages
- 18
[h=2]Hi all, i have got lots of email with the below format everyday(the table size is not the same everytime) , and have a excel sheet like the one below,
now I would like to compare the table in the outlook and excel, if two table is perfectly match, then copy the price in the email in paste it in the excel,
is it possible to do it with vba? and how to code ?
Thanks guys!
Outlook email:
AAA.Co[/h]Hello customer,
[TABLE="width: 500"]
<tbody>[TR]
[TD]Food[/TD]
[TD]Expiry Date[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]8/5/2017[/TD]
[TD]$9[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2/5/2017[/TD]
[TD]$8[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 397"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Caution: ....................................
Excel:
[TABLE="width: 397"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Food[/TD]
[TD]Expired date[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]09-May-17[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]08-May-17[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
now I would like to compare the table in the outlook and excel, if two table is perfectly match, then copy the price in the email in paste it in the excel,
is it possible to do it with vba? and how to code ?
Thanks guys!
Outlook email:
AAA.Co[/h]Hello customer,
[TABLE="width: 500"]
<tbody>[TR]
[TD]Food[/TD]
[TD]Expiry Date[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]8/5/2017[/TD]
[TD]$9[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]2/5/2017[/TD]
[TD]$8[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 397"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Caution: ....................................
Excel:
[TABLE="width: 397"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Food[/TD]
[TD]Expired date[/TD]
[TD]Price[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]09-May-17[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]08-May-17[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]