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.

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.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"AdP" <(E-Mail Removed)> wrote in message news:A94C46EF-B896-4B4F-8865-(E-Mail Removed)...
> 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.