How to capture the mail sent time, sent in IBM Lotus note 8.0.2 in Excel VBA 2003?

Which time exactly do you need?

I can think of many times associated with mails, but a lot depends on the way you received or sent the mails.

When i sent a mail i have to catch the email address as well as sent time and date into my excel sheet

If it is for your application only, it already knows the time the Sent button is pressed. Which mail address do you want to catch? The destination address is in your application, the sender is the person logged in, the owner of the mail database. You might try the following:
      v= Evaluate(@NameLookup ( [NoUpdate]; @UserName; "InternetAddress")

If you want to trace all mails passing through the server, you'd better ask the Administrator to enable Mail Journalling on the server.

i have to capture the the time and email address(To,CC,Subject) to excel sheet....


If u can give a example from outlook sent mails details to excel sheet it is also fine....

Sorry, your question is much too broad. Can you detail the question? I really need specifics. What exactly is your assignment?? With the emphasis on "exactly".

Did you have a look at the Mail Journalling feature of a Domino server?
See http://www-12.lotus.com/ldd/doc/domino_notes/Rnext/help6_admin.nsf/b3266a3c17f9bb7085256b870069c0a9/15bca374899a80f685256c1d00395e38?OpenDocument

Sorry. I do not understand what is the difficulty in understanding my straight  forward question.
When I send a mail to someone, it will be sent on some particular date and time and i want to capture the date and time of the sent mail for my automation. please find the image for better understanding.


Thank you    
-6781A3D24E1AD983.bmp