• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA - Extract outlook to excel

R

rsk

Member
Hi Guru's,


I need VBA to extract data from particular folder in outlook to excel,

i need (From name , receive time , Date , Subject).


Thanks and Regards

RSK
 
Rsk


+ Setup the view of the folder in Outlook as you want it by Right Click on the Column headers and choose the appropriate fields

+ Select the Records you want to extract or Ctrl A for all

+ Copy

+ Open Excel

+ Paste
 
Thank u sir,


But in received column am getting only day and dates, it should come (Mon 2/1/2010 4:46 PM) time not coming in my excel. I changed format cells too even though its not coming.


Pls help
 
Hi ,


Within Outlook , click on View -> Current View -> Customize Current View -> Format Columns.


Select the Received column and format it to show the date and time ; now do the copy and paste.


Narayan
 
You must log in or register to reply here.
Back
Top