extract outlook details using vba

[mrinal saha]

Hi Folks,

Is it possible to extract data from different folders in outlook to an excel sheet. There is a text box wherein user will enter the mail box name/id and run the macro. What I want is once you run a macro, it will go through each mail in inbox and throw data in excel in each row and column. and similarly for the other folders as well.

data will appear in the below format in excel.

Thanks,
Mrinal

From

To

Date

subject

<COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY>
</TBODY>

 

[pbornemeier]

Some guidance in these posts:

http://www.mrexcel.com/forum/excel-...-outlook-using-visual-basic-applications.html
http://www.mrexcel.com/forum/excel-...plications-excel-list-folders-subfolders.html