VBA Query - Copying Contents from Outlook into excel

[uzzimacro]

Hi All,

Hope everyone is well.

I wanted to create a macro in excel in which when I run it will look into outlook and for this specific email and copy and past the table data from this email into a same size empty table into excel. In more context I have to copy and past this from the email everyday and there are several emails, I just wanted a way of running a macro so it would copy the financial data inside that email in a specific range in Excel, e.g copy the table in the outlook email into H5:J15 which is on a specific tab in excel.

Appreciate the help

 

[uzzimacro]

Hi does anyone have any solution? would be greatly appreciated