Outlook to excel macro

cchristy

New Member
Joined
Feb 24, 2011
Messages
13
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)
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Salutations, I am xenny maw Recently moved from Iowa, originally from Des Moines and to this day miss my home town. I enjoy my free time,I love to experience all 4 seasons , specially the summer and the heat. Learning new things has been a part of my life for the last 7 years and most recently primarily on the Internet. I love the Internet. Things as they are, more and more people are seeking advice from people who have walked the walk and can teach others how to benefit from what they went through. I am here to help those that need help and will ask for help from other people when i need it. I am a manager in the field of Engineering and Scientific time management software. I am sharing my favorite websites , shutters in california aliso viejo shutters webside design in nyc website design new york Seatle insurance with car insurance seattle I love to ask questions I volunteer for valid causes that help the environment. I am to be a part of this Website and I am helpful.




website design new york - car insurance seattle - aliso viejo shutters
 
Upvote 0

Forum statistics

Threads
1,224,522
Messages
6,179,292
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top