Getting data from Outlook into an excel workbook.

JimmyDodger

Board Regular
Joined
May 3, 2007
Messages
159
Hi,

Is it possible to use Outlook as a data source for excel?

Specifically, I want to download the following from outlook into Excel.

Message subject.
Message recieved date.

Ideally, also I'd have the folder name as a column, but would be happy with seperate queries.

This would be as automated as possible, i.e. you just click refresh, as would need to run a report every day.

Jim
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,108,730
Messages
5,524,493
Members
409,584
Latest member
RedHelp

This Week's Hot Topics

Top