I am looking at how to obtain the attachment in Outlook (it is an Excel without table format) to be able to have the information and place it in another file (Excel).
3) Add a Table to the Excel Sheet bigger than what you know the table will be
4) List rows in the table
5) Filter the rows to remove blank (null) rows from the table
6) Use the output of the Filter Array #5 to add the rows to another file.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.