Outlook Macro Export Fields To Named Excel Workbook
Posted on 2013-05-21
I've searched EE for applicable macro code, but have not found anything that works.
From the Outlook 2010 Inbox we need to export 7 fields to an open Excel workbook, to specific columns.
We do this weekly, and the fields need to be added to the bottom of the prior week's export (exisisting data). There is a Header Row, so the first avaiable cell is A2.
The fields are:
Subject - column A
FromName - column B
FromAddress - column C
ToName - column D
ToAddress - Column E
ccName - Column F
ccAddress - Column G
I know this can be done manually in 2010, but we need a macro to turn this project over to others without training.
Any assistance or suggestions would be appreciated.