Extracting data from multiple email in email folder

Help
, , ,
1

Hi all, I am currently working on extracting data(a table and some individual texts) from multiple emails(same format) in an email folder and displaying the output on excel. However, am currently stuck as the excel is only displaying data from the first email in the folder. Really need help with this, hope to hear from somebody soon. Thanks in advance!

2

image
image722×177 11 KB

Try append range instead write range.