I would like to know if someone has some example code or knows of a book that can show me how to do the following:

I have to open 100+ emails that contain a subject line named Data and make sure that the sender replied only once. It would make life easier if I could do this programmatically. I have been searching for a while and I have yet to find a solution to my problem.

Thanks

Sketchit

Hi

You could use MS Access linked tables which you could use if you using a MS Exchange Mailbox. In the browse window on the Select Link table link window select Exchange() on the File of Types dropdown. You can the open the inbox in a table and use standard Trans SQL to do select, updates, deletes etc.

This is ussually the quickest way of doing these things but not the best for applications you would like to distribute.

Regards
Marnus