Guys, one more question . At the moment the macro extracts data from email to .txt file and there is separate .txt file for each email.
How can I change the code so that data is extracted into excel file instead and there is just one excel file stored in a location where all the data gets copied across so instead of separate file for each email , there is just one excel spreadsheet .
Any help will be much appreciated . Thanks.