Macro to fetch email subject line and Dates

[rajesh.pardhe]

Hi team,


can you help me with a macro.. where in i need to fetch the subject line, email date and sender name in an excel tabular format?


request you to help me with a vba coding.


Regards,

Rajesh Pardhe

 

[Hui]

Rajesh


Firstly, Welcome to the Chandoo.org forums


I believe that in Outlook if you setup your Outlook window correctly with the columns as you want them

Select all the emails Ctrl + C in outlook


Then In Excel Paste Ctrl + V

You should have a nice list


If you really want to do it in VBA I'd suggest reading: http://www.mrexcel.com/forum/excel-questions/52159-retrieving-data-mails-outlook-using-excel-visual-basic-applications.html

 

[rajesh.pardhe]

Hi Hui,


thanks for this however it is not helping me.. may be i am not able to understand some part of it..


at the begining only it is giving me an error "user defined type is not defined". the folder i have in PST is XYZ from wich i need to fetch the data in below format


Date/Time Subject Line Sender


The only thing in am changing in coding is chaning the folder name as "XYZ"


Please help me with this and let me know what all i need to change in the coding.


Regards,

Rajesh pardhe

 

[Hui]

If you have a PST open it in Outlook

In the main view arrange your columns as required by Dragging or use the Column Selector (Right Click on the column headers )

Copy and paste as I suggested above

Close the PST in outlook so it isn't connected anymore, unless you want it connected