Copy table from .msg files saved in a local drive into excel

[parangano]

Hi, quite new to VBA but I'm stuck. I have been able to extract attachments from .msg files saved in a local drive folder and then use Power Query to extract the tables from the attachments, but the challenge now is that the table data that I need is in the body of the emails.

Scenario: I have multiple .msg files saved in a local drive folder. Each .msg file has a table in it's body that I need to consolidate into an already existing file in Excel.

Any suggestions?