I have some answears now to reply you.

I have identified the poits what you have asked me.

To identify a particular message

1. from name (Display name of the sender)
2. from address (email address of the sender)
3. subject (subject is always same for example "Service Report dd-mm-
yyy")
4. There is always an attachment (Attachment file name:
SERREP_ddmmyyyy.xls)
5. Moreover the body of the message  is also always the same
for example
Dear Sir,

6. All mail are different due to the above 5 points.
7. My inbox is well structured with folders and sub folders and
further subfolders
8. I have with me a well defined address book (email comes only from
a known member)
9. Before mailing to exel vba  group I have also tried some of the
third-party software from www.mapi.com. They are not suitable for my
kind of problem. I have used an email attachment extractor here the
excel file name may differ because that name is fead by an operator
manually.

Hope receive help  from you. I am not much into programming but I
have some programming experience with "C".