Kingsford
10-05-2020, 02:51 AM
Dear experts
Good day , need your great help
Actually I am planning to write some VBA script to facilitate my work
I receive many emails a day and some emails with below
The subject is fixed format like “Order abc111 “
With an Html attachment file whose content will be like “Final price 123”
I want to write a script that when I receive this kind of email, It will
Find out all emails with subject contain “Order abc111” and its Html format attachment containing the words “final price “
Forward this email to another email address and also save the final price into a specific excel/text file
Your link above is a good reference to my idea , but I am still stuck at
How to read the html format attachment content ( getobject ?? )
How to forward the that email with VBA ?
Can someone teach me some hint?
Much appreciate
Good day , need your great help
Actually I am planning to write some VBA script to facilitate my work
I receive many emails a day and some emails with below
The subject is fixed format like “Order abc111 “
With an Html attachment file whose content will be like “Final price 123”
I want to write a script that when I receive this kind of email, It will
Find out all emails with subject contain “Order abc111” and its Html format attachment containing the words “final price “
Forward this email to another email address and also save the final price into a specific excel/text file
Your link above is a good reference to my idea , but I am still stuck at
How to read the html format attachment content ( getobject ?? )
How to forward the that email with VBA ?
Can someone teach me some hint?
Much appreciate