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 .
Thanks gasman . What changes do
I need to make in my macro so that we can extract data to excel file ? Suppose in one extract there are 100 emails so when the macro is run then it will extract data from those 100 emails to one excel workbook and save it down with unique name. Now when we do extract again with new set of emails then it should create another excel workbook with data from those emails and so on .
Any help will be much appreciated .
Well it is not a task to be taken lightly. Well not for me.
Start googling for something like transfer data from access to excel
If it was a table or query you could use CopyFromRecordSet, but as yours is piecemeal, I'd probably set each cell from your data variables.