Re: Extract data from mails on outlook and populate them in excel in specific feilds
And yes, I am using office 2016
Posts by Svenk
-
-
Hi,
I am looking for support on how I could export data from several emails that I receive to one excel format that has specific fields.
The content on my emails would vary but should have the keywords that will match the column headings on my Excel.A sample email looks like the below:
Hi,
Please find the data below:
Name : absd
ID : 564452
Description : Lorem ipsum
Price : $12
URL : www.xyz.com
email : "[email protected]"[/email]My Excel format would have the exact columns which I currently need to update manually.
It would be good if I can run a script that keeps adding the information on my email to my excel without having to do it manually.
Is there some way to do it?Appreciate your help.
Thank you
Svenk