• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Export the content in an email to an excel document under specific columns

Sarpun

New Member
Hi,
I needed help on how I could extract content from my emails in my outlook, if it has a specific subject line, then run through the content of that email and extract the content to an excel to specific fields.

I use Office 2016 and a sample format of my email would look like the below

----------
Hi,

Please find the data below:
Name: abc
ID : 676167
Description : lorem ipsum
URL : abc.com
email : xyz@abc.com
code : 55618993876

Thanks
----------------

I would need the above to be added to excel under specific columns. Is this possible?

Also, I would require to run this for my new emails and my older emails that has already come through.

Kindly let me know if anyone could help with this. I really am very new to excel or VBA. :(

Thank you
Sarpun
 
Back
Top