Hi all,
I have a macro which is able to export mails from Outlook to excel(thanks to some help on here )
The problem is i have to select the folder each time i want to export. I cannot find how to hardcode the values in.
Is there a way of recording a macro in outlook to go to the file>import/export>export to CSV> select folder.
My thinking is that if i can somehow generate the code similar to how the excel macro recorder would make it for one folder, i can reiterate it on all other folders i need to export(A Lot)
I have a macro which is able to export mails from Outlook to excel(thanks to some help on here )
The problem is i have to select the folder each time i want to export. I cannot find how to hardcode the values in.
Is there a way of recording a macro in outlook to go to the file>import/export>export to CSV> select folder.
My thinking is that if i can somehow generate the code similar to how the excel macro recorder would make it for one folder, i can reiterate it on all other folders i need to export(A Lot)