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

dbleal 0 Reputation points
2024-11-23T15:33:18.6666667+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,007 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,052 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.