I have some questions on how to extract data from the body of an email from two different folders which follows a structured format and place it accordingly into a data table to Excel. I have gotten so far to extract the data from the first email and place it into Excel. However, I cannot seem to add the last two columns from my second folder containing the other info in Outlook. Any help would be much appreciated!
Some pictures for example (Trying to get the last two columns to fill from a second folder in Outlook):