Copy an excel table from e-mail body and paste it into an excel worksheet - using vba

Question

I am trying to create a vba code that must find an specific e-mail subject, select the body data (that it's a table extracted from another excel file), copy and paste it into an excel worksheet.

Until now the program is working correctly to everything but the paste into another excel worksheet...

• Use an active instance or create a new instance of Outlook -> ok
• Find an e-mail with an specific subject -> ok
• Copy the body data specified in the program -> ok
• Find the first empty line on destiny worksheet -> ok
• Paste the data into that line -> Not working properly - i am stuck here

The data is being pasted only in the column "A", i am failling trying to distribute data through columns

The code is attached.

Thank you all for helping me.

Kind Regards

Sub ImportarEmailEventos().pdf