[RESOLVED] multiple times

Hi!
the below code is writing from outlook to excel
every day i run this macro. if i run
it will show existing sendername sent on received time adding several times in excel

Hi!
i have shared folders in outlook inbox which has saved inbox items as well as sent items
i am trying to extract inbox sendername and sent on and sent items - received time.
first time there is no issue. but second time run the macro from excel it adding old send itmes and inbox items into excel .
i have coding below please help this one.
thanks

wouldn't you need to check if each mail item has already been added into the excel sheet before adding it?
you could check by received time or some other property

how do i perform please let me know

each mail items is specific subject only i added into excel.
sendername sendtime received time
only three columns in excel

yes but each time you run the code it adds all the mailitems even if they were added before
assuming the sender and subject can be used many times the only value to check for is time /date

use excel's find method to check if the time of the current mailitem is already in the worksheet

Thank you Westconn,. i got it.