Automate export folder to Excel

[Guest]

I'd like to automate the File --> Import and Export --> Export to Excel -->
Outlook folder function.

I know it is possible to link an Outlook folder to an Access table, but
Excel will work better for my scenario.

Rules will be created to save emails from different recipients to different
folders, and content will be manipulated in Excel VBA.

Thanks a lot for any suggestions.

 

[Sue Mosher [MVP-Outlook]]

It is not possible to automate the Import and Export Wizard. See http://www.outlookcode.com/d/customimport.htm for examples of Excel export code.