• 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.

Copy data tables from Incoming Outlook Mail to Excel

vijay.vizzu

Member
Hi..all

I tried this to post in Outllook forums and searched a lot for getting solution. But I was unable to get the solution. So finally I decided to post this in this forum. If it is not compatible with this forum, then I request forum moderators to delete this post

My problem was, daily around 50 to 100 notification mails comes from our internal server. In that mail, a table contains some data. I need to copy that tables from each and every mails into excel sheet. After that, I need to do some formatting and send that mails to concern team.

Now my request is, I need to prepare a VBA code which can loop through all the notification mails in a specified folder, copy data from tables to excel sheet. I can create instance of outlook, but there is no option to recognise the tables in the body of outlook mail.

So please share your valuable comments.
 
Dear Deepak

Thank you so much for your links. But I am very sorry to say this, I can't figure out the right way.
 
Back
Top