Copy data tables from Incoming Outlook Mail to Excel

[vijay.vizzu]

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.

 

[Deepak]

Hi,

Pls check with below links...

http://stackoverflow.com/questions/...able-pasted-in-outlook-message-body-using-vba

http://stackoverflow.com/questions/3949918/copy-email-to-the-clipboard-with-outlook-vba

http://stackoverflow.com/questions/19436212/copy-table-in-email-to-excel-using-vba

 

[vijay.vizzu]

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.